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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Kevin_Yang
Frequent Visitor

Cannot Choose data with current layout to export data

I cannot Choose data with current layout to export data, and the visual that I take data from is a table.

 

Any feedback would be helpful, thanks.

 

Kevin_Yang_0-1713507265205.png

 

1 ACCEPTED SOLUTION
Bmejia
Super User
Super User

Check that your report was publish with one the below to options in the File/Setting & Options/Options/Report Setting

Also make sure that you are clicking on the right "..." that correspond to the table.  This has happend to me in the past where i had a  drop down filter very close to the table and I am actually clicking on the dropdown filter "..." rather then the actual table i am trying to extract giving me the apperance as in your screen that there is nothing to export.

Bmejia_0-1713561277543.png

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Thanks solution from @Bmejia 

Hi, @Kevin_Yang 

Are you using Power BI report server? The Data with current layout option to export data from matrix visuals isn't yet available in Power BI Report Server. This feature was developed in a different part of Power BI and is not yet included in Report Server:

Compare Power BI Report Server and the Power BI service - Power BI | Microsoft Learn

vjianpengmsft_0-1713851849649.png

The following one is a similar idea shared on Power BI Ideas, you can vote it up and add your comments there to improve Power BI on this feature. 

Microsoft Idea

 

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

Bmejia
Super User
Super User

Check that your report was publish with one the below to options in the File/Setting & Options/Options/Report Setting

Also make sure that you are clicking on the right "..." that correspond to the table.  This has happend to me in the past where i had a  drop down filter very close to the table and I am actually clicking on the dropdown filter "..." rather then the actual table i am trying to extract giving me the apperance as in your screen that there is nothing to export.

Bmejia_0-1713561277543.png

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors