Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
I am running a large report that will produce 10,646 rows and 61 columns when complete.
My issue is trying to load all rows automatically without having to load them a few at a time. I also am hoping to export it all in one easy go.
At first (in power BI) the report loads all columns fine, but only a portion of the rows. when I scroll down to the bottom, it will take its time loading another portion of rows, and so fourth until I reach the bottom. This will take an entire day of scrolling and waiting and scrolling and waiting.
The reason I need to do this is because it will only allow me to copy/paste the data out of BI and into excel and if I do not pre-load all rows, it will only copy/paste the visable portion.
(also would love to hear easier ways to export data, since this method only allows me to do a column at a time. Says too much data)
thanks so much, and hoping this makes sense.
Hi @emilyw316 ,
I would suggest you refer to this article, there are three ways to export data:
1. Copy Data from Data View in Power BI Desktop and Paste it to Destination
2. Copy Data from Query Editor in Power BI Desktop and Paste it to Destination
3. Export Data From Power BI Desktop to CSV or TXT Using DAX Studio
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.
When using a Table visual in PBI Desktop, you can actually export it to a CSV file:
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Proud to be a Super User!
Hi @emilyw316
first of all we should define where exactly do you scroll the data
there are 3 options:
1. Power Query Editor mode. It is the only preview of data and it will be incomplete
2. Report mode Data window. It is the not the best way to copy data into Excel
3. Report mode visuals. It has Export data options. It will export to csv and after that you could split cell by delimiter. Read more here https://docs.microsoft.com/en-Us/power-bi/visuals/power-bi-visualization-export-data
do not hesitate to give a kudo to useful posts and mark solutions as solution
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.
Proud to be a Super User!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
87 | |
67 | |
49 |
User | Count |
---|---|
135 | |
112 | |
100 | |
68 | |
67 |