Exporting Large Files from Power BI

[melanielane]

I need to export large files from Power BI.  I am having a problem with the numbers on my PBI screen do not match my CSV output.  I have cut up my data and exported it in small line amounts so there won't be a limitation problem.  Even when I export small amounts of data the PBI screen does not match my output.

I have used DAX studio and Power Pivot.  Power Pivot works but is very slow.  I can only export my table data from Dax studio and do not know how to transfer my report from PBI to Dax Studio.

Can someone help me with this problem? Is there a way to transfer my PBI report to Dax Studio so I can export it? or does anyone have any other solutions for exporting?

[djurecicK2]

Hi @melanielane ,

 You might want to consider Analyze in Excel or Export to Excel with live connection:

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel#analyze-in-exc...