Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 35 | |
| 33 | |
| 32 | |
| 27 |
| User | Count |
|---|---|
| 136 | |
| 96 | |
| 77 | |
| 67 | |
| 65 |