Export whole table in Excel

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

Anonymous
Not applicable
8 years ago
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.
Anonymous
Not applicable
8 years ago
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).
v-piga-msft
Resident Rockstar
8 years ago
Hi abhi9255,

The answer of Anonymous and Anonymous 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

Forum Discussion