Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Export Data from Power BI / Power Query to CSV / Excel and limit

Hello ,   My question is very sample :   1) When I use Power Query and that I agregate 2 tables, it's possible to export the new table in Excel or CSV directly from Power Query ?   2) In Power ...
Tips and Tricks
  • rsaprano's avatar
    rsaprano
    6 years ago

    Hi Anonymous 

     

    There are limits on the export volume from both the query editor and exporting data from a visual. The best way to get data from your Power BI model into Excel/CSV (as a one-off) is to connect to it via DAX Studio, write a DAX query to return the data you want (for an entire table you could write EVALUATE('Table Name') ), set the output to file and then run the query.

     

    Some of the other options (e.g. running a R/Python script in the query editor, using Power Automate and/or APIs) are a bit more complex and probably only worth it if you need to extract the data on a regular basis.

     

    Thanks

     

    Rishi

     

rsaprano's avatar
rsaprano
Most Valuable Professional
6 years ago

Hi Anonymous 

 

There are limits on the export volume from both the query editor and exporting data from a visual. The best way to get data from your Power BI model into Excel/CSV (as a one-off) is to connect to it via DAX Studio, write a DAX query to return the data you want (for an entire table you could write EVALUATE('Table Name') ), set the output to file and then run the query.

 

Some of the other options (e.g. running a R/Python script in the query editor, using Power Automate and/or APIs) are a bit more complex and probably only worth it if you need to extract the data on a regular basis.

 

Thanks

 

Rishi

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

rsaprano,

 

Thanks for this information.

 

I note this .