Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
Solved! Go to Solution.
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.
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
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.
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.
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.