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!
Let me know if that works!