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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
oscar_zapi
New Member

Issue when exporting data from a matrix

Hello all,

I have the issue that when I create a measure to be shown at a certain level of the matrix, other than the very first level, I am able to export that data column and view it along with the others. The problem comes when I try to create a similar measure but that will be shown only at the very first level of the matrix, and not the rest, export data shows for that column as blank. 

So I've tried different approaches of creating the measure, but none of them seem to work if the measure appears at the very first level of the matrix, but it does work when exporting for other sublevels. 

Any facing this issue before, 

PFA the image to see better with sample data.

Thank you in advance for your help.EXPLANATIONS.png

3 REPLIES 3
lbendlin
Super User
Super User

Instead of exporting like that consider using Analyze in Excel, or export with live connection.

Thanks, But as this is supposed to be exported from the report server, I think it may not work. Not sure if it's a bug for this scenario. 

Still, thanks for your answer

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.