Forum Discussion
Helper IISharing the Table View and Report View. Able to export to Excel
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.
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.