How can we improve Power BI?

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.

1 vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

kelleyamattTGS shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.