Skip to main content
Microsoft Idea

Power BI

Needs Votes

Allow Power BI Desktop to Create Perspectives (Similar to Power Pivot, SSAS)

Vote (223) Share
Avi Singh's profile image

Avi Singh on 21 Nov 2018 10:33:47

Perspectives are an incredibly useful feature for complex models for end-users. For a complex model, there can be 50+ Tables with 100s of Columns and Measures (sometimes 1000+). This can be overwhelming for a new user who would connect to the Data Model to create their own reports (either using Power BI or Excel).

Adding the ability to create Perspectives in Power BI Desktop (similar to Power Pivot, SSAS) would be a big help.

Perspectives allow end-users to connect to a "slice" of the Model, making it easier to understand and work with. Thus aiding with the widespread adoption and rollout of Power BI.

Power On! / Avi

Comments (13)
Avi Singh's profile image Profile Picture

Barny on 05 Jul 2020 23:27:29

RE: Allow Power BI Desktop to Create Perspectives (Similar to Power Pivot, SSAS)

Please also add the ability in Embedded to select which perspective to show

Avi Singh's profile image Profile Picture

Renaud on 05 Jul 2020 22:32:49

RE: Allow Power BI Desktop to Create Perspectives (Similar to Power Pivot, SSAS)

totally agree. Not only it would be nice to be able to manage perspectives in Power BI, but at the moment it is creating issues when importing data model content from an excel.
I ran into some issues whereby i wasn't able to delete some tables / columns in power bi as they were linked to some perspectives from the original imported excel data model.

Avi Singh's profile image Profile Picture

Rory on 05 Jul 2020 22:08:06

RE: Allow Power BI Desktop to Create Perspectives (Similar to Power Pivot, SSAS)

Some means of creating and using perspectives would be terrific

Merged Idea (2)