Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

Hexekutive

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

Submitted by Advocate II on ‎07-20-2023 12:51 AM

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
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎07-21-2023 01:52 AM

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
Advocate II
‎07-21-2023 02:27 AM

Hello, @Anonymous 

 

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

 

Best regards,

Hexekutive

Idea Statuses