Forum Discussion
Export more than 150 000 rows into excel
- 2 years ago
Hi Anonymous ,
Have you tried this option: Analyze in excel
Also another way what you could try is connecting your powerbi dataset directly to the deseried excel file.
Refer to for more details:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-connect-excel-power-bi-datasets
Let me know if this aligns with output you are expecting.
I hope I was able to resolve your issue. If so please mark it so it can help others as well.😊 - Anonymous2 years ago
Hi Anonymous
Power BI doesn't currently support exporting more than 150,000 rows of data from Power BI service visuals for end users.
It has been listed as a restriction in official documents:Export data from a Power BI visualization - Power BI | Microsoft Learn
You could export your data with the help of filters such as Slicers, which means you could export parts of the data in each export.
You can also use DAX Studio, a free community tool, to export your data very fast and even export your whole model at once.
Solved: Exporting a large number of rows from Power BI to ... - Microsoft Fabric Community
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
No other solution than paginated report however a work around could be create 2 filtered visuals in 2 different pages in the report and end user can export and combine the outcome.
Thank you aj1973 the matrix is dynamic per selection of user through field parameters. I guess this might not be the good practice for the end users 😞