Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am using Power BI Desktop and Report Server Sep 2019 version. In Power BI Desktop, I set Options - Report Settings - Allow end users to export both summarized and underlying data.
Getting errors if I try to export data on the server for a report with around 4M rows. When I try same report in Power BI Desktop I get a warning, .csv file is then exported with only 30K rows. Is this a limit by Power BI? Are these limits the same for Power BI service? Will these limits increase with future version? Also, the published report on report server shows errors because it doesn't like the option to export summarized and underlying data :
Hey @ahpitre2,
yes, there is a limit that also exists in Power BI Service:
If you have Power BI Premium, you can create a paginated report that allows to export to csv or xlsx without any limitation.
Regards,
Tom
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
91 | |
81 | |
65 | |
65 | |
60 |
User | Count |
---|---|
170 | |
114 | |
102 | |
73 | |
69 |