Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I suspect this comes with the November update. When I try to do an Export Data from a Matrix or Table I am now getting a Data Exceeds the Limit error, I used to be able to Export data with a wide date range but after the update it's now giving me that even if I select a single date to export.
What's going on?
Solved! Go to Solution.
Hey,
the documentation states that there is a limit of rows that can be exportet to csv, this limit is 30000 rows.
Using the target format xlsx this limit is 150k rows, the export to xlsx option is available in Power BI Service.
These limits are described here:
https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-export-data
Please don't ask me why such a limit exists 🙂 I'm just the messenger
Regards
Tom
@LY18 , you can't access Excel option from Power BI dev app. You can see it only from the published report. So save, publish, go to report url, then the export pop up will ask which format.
Thanks, but that is definitely new information and I think everyone who came to this thread aren't aware. Prior to November update there was no such limitation.
Okay then I think I rest my case, though I'm curios WHY.
Limits it is!
You can't, unless you count the rows in your visual. As a workaround, I suggest using the October version until this gets fixed permanently,
@ovetteabejuela,
The fix of this issue will be released on January.
Regards,
Lydia
I too have this issue - and running on the Jan '18 update.
What is the status on this issue??
I'm running the Version: 2.56.5023.942 (March) and still have the same issue. Also, it seems a maximal number of rows which can be exported is 30000!
Thanks for raising this issue. I have the same problem and look forward to the Jan '18 solution
As a temporary workaround, you can try reverting to the October version or you can ignore the warning for datasets smaller than 30k rows.
What more I have observed is that if it reaches a certain number of rows, it removes duplicate columns which I intentionally placed but if it's less rows it just leaves duplicate columns alone.
So probably I could say it does not truncate by rows(to a certain number maybe 30K or 100K) but it certainly does remove duplicate columns.
I will test this tomorrow morning. If you have any datasets you have used in your tests please share. Thank you.
@ovetteabejuela,
I can reproduce your issue in November update. Based on my test, the message will throw when you export >=500 rows data. When your visual contains >=500 rows data, as long as you click "Continue" button, the data will be exported in CSV properly.
Besides, I will report this issue internally and post back once I get any updates.
Regards,
Lydia
Thank you for looking and kindly post back. Okay so the "Continue" option will not truncate anything?
As of now I recreated everything in Excel PowerQuery just for that portion where we need the data exported in CSV.
@ovetteabejuela,
When I test with 10000 rows and use Export data option, the data are not truncated, but for the specific limit, we still wait for PG's response.
Regards,
Lydia
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |