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

[rnoone1]

Some means of creating and using perspectives would be terrific

[renaudmasson]

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.

[Barny]

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

[fbcideas_migusr]

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.

[g_apostolakis]

We develop reports based on a certified dataset which is used for the whole company. We have especially one report regarding management review meetings which should contain metrics from all departments. But we cannot include HR data to this dataset, due to confidentiality. So we cannot add those to the management report and having different sets is not working. Dashboard could solve it but lets face it... creating a dashboard is very limited comparing to a report looking like a dashboard, with bookmarks and actions.

[Marc_Lelijveld]

I totally agree that it would be very welcome to view, manage and maintain perspectives in the model view of Power BI Desktop. Especially since perspectives are now also used for visual personalization purposes. https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2020-feature-summary/#_Perspectives

[me5]

This was always available in Power Pivot as far as I can remember. It seems we took a step back with Power BI, since this feature was dropped 😞 Would certainly be very useful.

[glennj1]

Thanks for all the great improvements, we are finally switching over. I agree with the need for this, this will save us from having to have a version of each of our reports so we should be able to dramatically reduce our report count if we can get this. We are a shop that uses PBI embedded is is possible to pass the perspective into an embedded report since we know which perspective our user would want to start with? Thanks again.

[fbcideas_migusr]

Great idea! Waiting for this

[nishalit]

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 directly to an Excel PowerPivot Data Model instead? Maybe PowerPivot data models could be exported into a Services Connector readable format? I'm not a BI Developer, just spitballing here.