Data limit exceeded for power bi dashboard

SamvittiTech — Wed, 06 Sep 2023 05:00:08 GMT

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

Re: Data limit exceeded for power bi dashboard

Martin_D — Wed, 06 Sep 2023 09:22:19 GMT

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-builder
- 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.

Martin