Forum Discussion
Problem loading all rows of data
Hi, Thanks a million for your responses. I unfortunately have "Data exceeds the limit" when I try to export to CSV by clicking the 3 dots in the visual.
I have a matrix in the Report view that is a little over 10.6k rows and 61 columns wide. I found the only way I can export data is if I copy and pase a column at a time into excel, which is incredibly frustrating. Not only is that tedius but before I can even do that, I have to load all the rows so I get all the data into excel. (if I do not load all first, it will only copy the loaded portion into excel.)
To load all the rows I have to scroll to the bottom, more will load, scroll to that bottom, more will load, and so forth until all rows are loaded. then I begin my copy/paste hours of each column into excel. This takes almost 2 full working days to complete !
Are you familiar with this issue and have any insight? I am (perhaps obviously) fairly new to Power BI and learning it for my company but running into these issues.
Thanks so much, appreciate you!
Hi emilyw316 ,
As mentioned before, I would suggest you use DAX Studio. An advantage of using DAX Studio is that it works great regardless of the amount of data you want to export.
Refer to the resources below, you will find the method:
Export Data from Power BI Desktop to CSV or TXT Using DAX Studio
Export to csv from Power Query
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.