How to export PBI data to excel ?

[Anonymous]

Hi All

[amitchandak]

@Anonymous , Create a visual and export.

Or

Right click on table Copy Table and paste in excel

refer  video

https://www.youtube.com/watch?v=1_XlyzV-PcY&t=41s

[Anonymous]

Hi @Anonymous 

you will have to add the data in table visual and click on elipse(...) and export the data

[Anonymous · Accepted solution]

@Anonymous  also note that 
The maximum number of rows that Power BI Desktop and Power BI service can export from an import mode report to a . csv file is 30,000. The maximum number of rows that the applications can export from an import mode report to an . xlsx file is 150,000

If this helped you kind mark this as solution so that it can help others too