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 2018-11-21 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) Merged Idea (2)
Vote 25
Stevith's profile image

Stevith on 2015-08-12 10:20:07

Power BI

Ability to connect to Perspectives stored in an Excel Power Pivot data model as a dataset OR ability to create perspectives in PowerBI

and then be able to share those datasets. Using perspectives with PowerBI would be a great way to hide sensitive data and make large data models more manageable. PowerPivot for Excel is pretty much SSAS anyway right? Would it be possible to use the Analysis Services Connector to connect direct...

Merged
Vote 60
's profile image

on 2019-05-05 09:36:00

Power BI

Dataset Perspectives

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 Mode...

Merged