Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply

Sharing 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.

1 ACCEPTED SOLUTION
v-xuxinyi-msft
Community Support
Community Support

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:

vxuxinyimsft_0-1717744102012.png

 

Report View:

I then filtered as shown.

vxuxinyimsft_1-1717744195020.png

 

vxuxinyimsft_2-1717744316428.png

 

Output:

vxuxinyimsft_3-1717744358209.png

 

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.

vxuxinyimsft_0-1717750903046.png

 

Output:

vxuxinyimsft_1-1717750944608.png

 

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.

View solution in original post

1 REPLY 1
v-xuxinyi-msft
Community Support
Community Support

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:

vxuxinyimsft_0-1717744102012.png

 

Report View:

I then filtered as shown.

vxuxinyimsft_1-1717744195020.png

 

vxuxinyimsft_2-1717744316428.png

 

Output:

vxuxinyimsft_3-1717744358209.png

 

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.

vxuxinyimsft_0-1717750903046.png

 

Output:

vxuxinyimsft_1-1717750944608.png

 

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.