Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hi,
Our PowerBi (Semantic model) report in Teams cannot export to excel via the option "Data with current layout" anymore. It used to work and no changes have been made. See screenshot. the option is now greyed out.
Does anyone know how to resolve this without a major scope of work.?
Thanks in advance. 🙂
Solved! Go to Solution.
Hi @Newbie777 ,
Below is my report which is published to service. It is showed export the data with current layout.
export the data with current layout must be a table or matrix visual object to be used, all other visual objects are greyed out.
My current version of the service and the desktop version published to the service are:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Newbie777 ,
Below is my report which is published to service. It is showed export the data with current layout.
export the data with current layout must be a table or matrix visual object to be used, all other visual objects are greyed out.
My current version of the service and the desktop version published to the service are:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 16 | |
| 10 | |
| 10 | |
| 8 | |
| 7 |
| User | Count |
|---|---|
| 40 | |
| 36 | |
| 34 | |
| 28 | |
| 20 |