Export to Excel Table from Power Bi

[sanket_sk]

Hi All,

I have developed a report in Power BI desktop using various DAX formulas and calculations, report has two or more pages, the report is in table format only. users are accessing this report online

Now I am looking for a solution (formula / VBA or any other trick) by which I can create an export to excel button which will extract two or more pages from the Power BI desktop & online both and save them in a single excel workbook.

Please guide me to perform this activity.

Sharing sample snaps for better understanding ..

 

[pjmorris]

I dont believe you can do this. The only export option i'm aware of is to clicke the ellipsis at the top of the table and select Export. It allows you to export it only as a .csv

Perhaps you'd be better copying the query into excel?