Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to Solution.
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
49 | |
28 | |
21 | |
20 | |
20 |
User | Count |
---|---|
52 | |
51 | |
27 | |
26 | |
22 |