Forum Discussion
igreenjay
2 years agoNew Member
Is There A Way To Export .PBIX Files To .CSV Past 30k Rows?
Current Situation: working on a page that embeds power bi reports using .pbix files and has actions that allow for users to export their reports as CSV or PDF. We are exporting to CSV data via the Ja...
Anonymous
2 years agoNot applicable
Hi igreenjay ,
Thanks for reaching out to us with your problem. Base on your description, it seems that you are trying to export the data with 30k rows. The following links are the threads which has the similar requirement as yours, hope they can help you resolve the problem.
Using R or Powershell:
Solved: Export huge amount of data from one pbix-file and ... - Microsoft Fabric Community
In follow up, you might also try using R to export the data from your .pbix file as explained here: https://community.powerbi.com/t5/Community-Knowledge-Base/Export-dataset-into-a-file-from-Power-BI-D...
you can try this, it is using powershell, i tried it myself with 8 millions rows, and it worked.
https://github.com/djouallah/PowerBI_Desktop_Export_CSV
Using DAX Studio:
Best Regards