Data limit exceeded for power bi dashboard

[SamvittiTech]

Hi Team , 

I Have a power Bi dashboard with 8000 rows .On export to csv it shows data limit exceeded .

Entire Workspace usage is just 3 Mb .

Kindly Suggest

[Martin_D]

Hi @SamvittiTech ,

Actually there are CSV export size limits as per documentation https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-d...

Possible workarounds:

• Excel export has extended size limits
• Create a paginated report for CSV export. This can also be embedded into a Power BI report or dashboard using the paginated report visual. This way also filters can be applied before exporting the file.
  • https://learn.microsoft.com/en-us/power-bi/paginated-reports/report-builder/export-csv-file-report-b...
  • https://learn.microsoft.com/en-us/power-bi/visuals/paginated-report-visual
• Use an external tool to read from the dataset (XMLA API) and write the CSV file, e.g. using Azure Data Factory calling the execute queries Power BI REST API method https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries and Azure Data Lake to store the CSV file. Then you can put a tile with a link to the export folder on your Power BI dashboard. The external could also just be Excel using Get Data connection to the dataset from within Excel.

BR

Martin