Data exceeds the limit

[PowerBIBeginer]

Hello All,

I'm trying to export some records using 'table' control. The total records are 42,000 but when I'm trying to export it only eported 30,000 and this below waring msg popped up.. any guidance how do I download entire that records..?

Data exceeds the limit

Your data is too large. Some data sampling may occur.

[v-yalanwu-msft · Accepted solution]

Hi, @PowerBIBeginer ;

According to the official documentation:

• The maximum number of rows that Power BI Desktop and Power BI service can export to a .csv file is 30,000.
• The maximum number of rows that the applications can export to an .xlsx file is 150,000. The actual number may be lower than 150,000 depending on query limits and visual types.

Using DAX Studio we can get around these limits.

1) Open DAX Studio

2) Connect to your model

3) Copy this code into the main window

EVALUATE( myTable )

4) Go to Output -> Static (Excel) for .xlsx and File (Standard) for .csv

5) Click on Run or press F5

https://en.brunner.bi/post/exporting-data-from-power-bi-desktop-without-limits

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@PowerBIBeginer , check if power automate can help

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-automate-power-bi-report-export

[PowerBIBeginer]

Hi Amit, Thank You for quick reply. But I want to export from power bi desktop. actually there are just Id's which Im trying to get.. Is there any simpler way please