Sharing the Table View and Report View. Able to export to Excel

[irfan_abdrhman]

Hi Community, I want to know how do I export the information of the Dashboard into Excel. I want the data from Table View/ Power Query and also the filter-able Dashboard in the Report View to be extracted  / exported to  Excel. Please help and thank you.

[Anonymous · Accepted solution]

Hi @irfan_abdrhman 

If I understand correctly, you want to export the full data in the table view/Power Query in Power BI desktop, and then export the filtered data in the report view in desktop?

The following test is for your reference:

My sample:

Report View:

I then filtered as shown.

Output:

According to my test, it seems that it is not possible to export data from table view or Power Query to Excel. You can create a visualization table with complete data and then repeat the above steps.

Output:

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.