How to transform in power query an Excel table format that is grouped ( '3 headers' )

[Anonymous]

So, here is how my Excel "headers" look like.
I want to load this table in my power bi report and I don't figure out how to keep the "header" structure .

Thanks for any ideas !

[wdx223_Daniel · Accepted solution]

multi-level headers have no use in power bi. had better flat the table into one dimension 

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

Like @wdx223_Daniel  said, Power Query does not have multi-level headers, you can merge multiple rows of headers of a column into one in Excel and import them into Power BI.

Or please kindly refer to

Working With Multiple Row Headers From Excel in Power Query — ehansalytics

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[wdx223_Daniel · Accepted solution]

multi-level headers have no use in power bi. had better flat the table into one dimension