Forum Discussion
Excel grouping row function
Goodmorning to everyone, Here's the issue: I'm trying to upload an excel as dataset of my report in power Bi. The problem is that the file excel is formatted with the grouping function, that rep...
The issue is that it seems that power bi cannot read the indent of the original excel file
I see what you mean about the "indent" of the grouping.
I can't find anywhere that this grouping is shown in the meta data that is visible to Power Query, so unfortunately, I think you're going to have to modify the source file somehow to add an identifier for the grouping levels.
I think I found a solution with a macro, so I can modify my original file and then give it to power bi. The next problem is how can i flatten the hierarchy once I upload my dataset in Power Bi. I tried everything (form sostitution, to path, pathitem, etc...) but I cant find a solution.
This is my new excel: sample 3