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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! 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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.