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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Bug: Data with current layout not working, exporting always first level on the hierarchy

Hi! 

 

Today we discovered a very annoying bug: when exporting with the current layout, Power BI is not picking really the "current", but the first level available in the hierarchy.

 

In the below example, you see my matrix is showing the attributed "GBF" which is the third in the hierarchy. However, when I export with current layout, Excel shows the Region, which is the first item in the hierarchy.

 

The workaround for now is to delete the first two attributes so it works, but this is new! It was not happening before.

 

Would appreciate a lot your support, as our +700 users are impacted. Thank you!

 

Hexekutive_0-1689839296830.png

 

Hexekutive_1-1689839429192.png

 

Hexekutive_2-1689839436047.png

 

Hexekutive_3-1689839442388.png

 

 

Status: Needs Info

Hi @Hexekutive 

What version of Desktop are you using for testing? Can you provide your pbix file(remove sensitive info) for testing?

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Needs Info

Hi @Hexekutive 

What version of Desktop are you using for testing? Can you provide your pbix file(remove sensitive info) for testing?

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

 

Best Regards,
Community Support Team _ Ailsa Tao

Hexekutive
Advocate II

Hello, @v-yetao1-msft 

 

This is happening on Power BI Web. I'm testing on a published app where users are consuming the report.

 

Best regards,

Hexekutive