Forum Discussion
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 Bi Desktop there are 3 possibilities to see data and link (report view, data view, model view ). In Data view is't possible to export data directly in CSV / Excel ( without usation of copy/past ) ?
3) When I'm in report view and that I use the component "matrix" or "table" , what is the limit of number of lines ?
I explain my idea, for example your database table of departure own 500 k , 1 millions or more of lines. You have need to export a specific list of elements with a particularity, the list own 100 k lines. The option "export in CSV/Excel" give complete list or it's limit to 65 000 lines like the old version Excel ?
Thanks for your help
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
2 Replies
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