How can we improve Power BI?

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

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

55 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Avi Singh shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Nick commented  ·   ·  Flag as inappropriate

    We are very impressed by Power BI and want to replace our old SSAS multidimensional cubes with a Power BI model. However, many of our users will still want/need to connect to the Power BI model with Excel for ad-hoc reporting. Perspectives are a requirement for this so that users are not overwhelmed by the entire enterprise model and so they can have a similar experience to what they already have in SSAS.

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.