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

[avi2]

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

[nishalit]

The new modeling view in Power BI Desktop supports multiple layouts and many features (multi-select) that make designing large models easier. Perspectives should be added to the new modeling view with a 'Manage Perspectives' icon next to the Manage Relationships and Manage Roles icons on the Modeling tab. In an initial release, the Manage Perspectives dialog should provide the same features as what's available to Analysis Services projects in Visual Studio. For instance, there should be a table with each column representing a distinct perspective and the modeler can quickly choose which tables and individual measures and columns are included or not in a given perspective. Additionally, also like Analysis Services, the modeler should be able to view/evaluate and toggle between the different perspectives to view the user experience.

[David_Mellinger]

This is THE feature from Analysis Services which is missing to make Enterprise models/datasets more usable in Power BI. It really is the only feature which I can talk with end users or others about which I could recommend Analysis Services over Power BI for enterprise models. Get perspectives fully implemented in Power BI!!

[denis_peyras]

Hi,

Tabular Editor can add "Perspectives" on an existing Semantic Model.

When using Power BI Desktop, the idea is to add a combo box in the Data panel. The combo box will contains all defined perspectives.

Thus, user can understand the dimensional matrix and avoid tu use measures or dimensions in bad context.

Regards,

Denis

[CHedeen]

Any update on this? The original post is over 6 years old and I still have not found a solution to replacing perspectives.