Forum Discussion
What is the Export data row count limit for Power BI Report Server?
We seem to be limited to exporting 30,000 rows of data with Power BI Report Server, but we can export 150,000 rows in Power BI Service. Is there an official row limitation for Report Server and is anyone able to export more than 30k rows? This is a big limitation for us and I truly hope there is a solution.
Hi Anonymous,
After confirmation from PG internally, we can only export data to .csv currently. And maximum number of rows that can be exported .csv is 30,000.
Best Regards,
Qiuyun Yu
18 Replies
v-qiuyu-msftCommunity Support
Hi Anonymous,
Based on my test, when we export data from a visual in Power BI report server, data is exported to .cs file instead of the .xlsx file.
From this article, the maximum data export to .csv file is 30,000 rows. I guess the limitation applies to Power BI report server as well. I will send a email to consult this issue internally. Will update here once I get any information.
Best Regards,
Qiuyun Yu- v-qiuyu-msft
Hi Anonymous,
After confirmation from PG internally, we can only export data to .csv currently. And maximum number of rows that can be exported .csv is 30,000.
Best Regards,
Qiuyun YuHi v-qiuyu-msft,
Yes, agreed. The Microsoft Power BI product team told us the same late last week: Power BI Report Server data export is limited to 30k rows, while Power BI Service can export 150k rows.
I was disappointed to learn that the underlying reason for this capability difference is to help drive the growth of Microsoft's cloud business. It is a shame that users of the on-premises solution are delivered a de-rated product (of a simple and fundamental capability) in order to make the cloud version appear more attractive. In our case, this means that painful and time consuming work-arounds will continue to be required simply to produce raw data for our finance group for their Excel-based analysis and reporting process.
As a huge fan and an advocate of Microsoft's "Power" suite, including DAX, I feel left behind by this marketing decision. I remain hopeful that this strategy will change and that users will be able to feel safe in adopting any/either of Power Pivot for Excel, Power BI Service or Power BI Report Server.
- messerjc
Advocate IV
That's extremely ridiculous - I would suspect those of us using this on-premises, the extact reason why we want something like PBIRS, would be even more inclined to do large extractions. I truly hope this is revisited as it may hinder our adoption of Power BI at all. Don't use the stick to drive people to cloud, right? Give me the carrot of a fully supported, fully functioning on-site Report Server, and I'll be more likely to leverage the Cloud service when it's appropriate for us.
