Export whole table in Excel

[abhi9255]

Is there any way to export the whole dataset which is published in Power BI into excel

[v-piga-msft]

Hi  @abhi9255,

The answer of @Anonymous and @Seth_C_Bauer should be correct, if you do solve your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you need additional help, please feel free to ask.

Best Regards,

Cherry

[Anonymous · Accepted solution]

Hi @abhi9255, 

If you have the pbix file, in Power BI Desktop you can go to Data View, right click on the table and select copy table, then paste it into your excel file.

If you have the option enabled you can download the pbix from the service in Files> Download report.

Regards.

[Seth_C_Bauer]

@abhi9255 Look into Analyze in Excel - https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel, but if you are referring to opening a visual (table) and dumping the whole thing out, then no).