Fix nomenclature of folders and attributes when loading Power BI SSAS Tabular data
We have the need to load data into Power BI from an SSAS Tabular model in order to capture existing calculations in the model and provide the ability to experiment with new calculations and/or relate cube data (including calculations) to data from an outside source. However- when loading data- If we want each entity to be represented in it's own folder (as we see when connecting live) we found we need to select each entity in the cube using a separate 'Get Data'/ Query. When doing so, the default name of each folder is the CubeName (or CubeName1, CubeName2...) and the name of each entity is EntityName.AttributeName.AttributeName. This is unexpected behavior and requires a lot of manual effort to have our loaded data appear with correct folder and attribute names. We could go against the Star Schema entities that feed the cube, but that would require us to manually recreate all the calculations in Power BI that already exist in SSAS Tabular.