Skip to main content

Power BI

Needs Votes

Increase Export Data Limits

Vote (1482) Share
Adam Wilson (POWER BI)'s profile image

Adam Wilson (POWER BI) on 24 Feb 2017 01:34:44

In late 2016, Power BI improved our export data options to allow exporting up to 150,000 rows to Excel from a visual on a Power BI dashboard for Pro users. If you require higher limits, please vote on this idea. If you have more specific requirements, please leave them in the comments.

Administrator on 30 Jul 2020 16:56:47

There are longer term plans to allow larger exports in that use case, but there isn't a current timeline as to when that will be available. Customers who have Power BI Premium can set a drill-through to paginated reports via URL parameters as a workaround in the interim, as there is no data export limit for paginated reports.

Comments (158)
Adam Wilson (POWER BI)'s profile image Profile Picture

66e1450c 13c3-4d1e-a812-9709bb01b774 on 06 Jul 2020 00:03:51

RE: Increase Export Data Limits

Nikhil/MSFT Team, Please let us know the latest update on this.

Adam Wilson (POWER BI)'s profile image Profile Picture

dbe4fb98 22d6-41e5-a092-77d7db5b57a9 on 06 Jul 2020 00:03:12

RE: Increase Export Data Limits

Need this limit to be elevated ASAP please

Adam Wilson (POWER BI)'s profile image Profile Picture

87dbae7d f464-4378-850f-335f13f6205d on 06 Jul 2020 00:01:52

RE: Increase Export Data Limits

Why not have it match the excel limits for starters.

Adam Wilson (POWER BI)'s profile image Profile Picture

a5b83494 a217-41aa-8b66-84fe9a57af0b on 06 Jul 2020 00:01:44

RE: Increase Export Data Limits

MSFT Support - Please let us know when the limit will be increased. It should be atleast 500K for excel to meet our business requirements

Adam Wilson (POWER BI)'s profile image Profile Picture

8908b92b 0d3f-4386-a0b8-aeefe7f9fb09 on 06 Jul 2020 00:01:26

RE: Increase Export Data Limits

Planned from March 31, 2018???? Its a joke!!! More than year ago.
Come on!!!! This feature is highly important and necessary.

Adam Wilson (POWER BI)'s profile image Profile Picture

4d8b7e10 5030-4223-bc7a-32fe54f28f31 on 06 Jul 2020 00:01:17

RE: Increase Export Data Limits

The current limit is ridiculously low. As a Power BI Pro user I can only export 30k lines of data to CSV. Please consider raising it to the limits Excel allows for their workbooks.

Adam Wilson (POWER BI)'s profile image Profile Picture

041d227d 7823-46b9-938e-54a67a07c249 on 06 Jul 2020 00:00:52

RE: Increase Export Data Limits

If Microsoft doesnt increase the limit of number of rows to export to .csv and .xlsx then we cannot be able to use microsoft Power BI as our enterprice solution. Please do the needful.

Adam Wilson (POWER BI)'s profile image Profile Picture

9a10b183 5aec-45dd-9803-4f1cff64f148 on 05 Jul 2020 23:57:47

RE: Increase Export Data Limits

Power BI Service needs to increase the limit for # of rows to export to .csv and .xslx.
This is in high demand by our business users in order to keep business momentum moving forward.

Adam Wilson (POWER BI)'s profile image Profile Picture

717ce95c 5c20-4997-9e0a-b41d0b4809f4 on 05 Jul 2020 23:57:38

RE: Increase Export Data Limits

This seems like a very simple issue to resolve. I know there are many other priorities, but the workarounds for this limit take far more effort than I think an actual fix would take. Is there a specific timeline for resolution? Thanks!

Adam Wilson (POWER BI)'s profile image Profile Picture

c31a51d2 5ef1-469f-a5c4-5fc48e8797ca on 05 Jul 2020 23:56:27

RE: Increase Export Data Limits

Why are limits necessary?