Forum Discussion
Export error: "Your data is too large. Some data sampling may occur."
This is a known issue, please vote the idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9609906-export-powerbi-desktop-to-csv-excel
I suggest you directly import the source data into the Excel/CSV file. For example, if it's from SQL table, you can copy the query result set into Excel worksheet.
Regards,
This idea seems like it pertains more to your posting: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31837054-don-t-limit-download-data-file-sizes
I'm running into the issue too and the data isn't even that big. Frustrating.
I got around this by publishing to my workspace and exporting (summarized data) from there and it worked successfully. We are using live connection to SSAS though so not a difficult option for us to do it this way.
The publish to workspace method works well. For some reason the Web Interface allows to export to .xlsx which has a max of 150k rows. I was not able to find how to enable .xlsx export in PBI Desktop.
Hi
I want to know how Large data can be exported to csv/xlsx from Published power BI report. Currently some data are missing from the exported csv file compared to the original matrix.
