Forum Discussion

PowerBIBeginer's avatar
PowerBIBeginer
Helper V
4 years ago
Solved

Data exceeds the limit

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.

Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

     

3 Replies