Power BI
Needs VotesAllow Power BI Desktop to Create Perspectives (Similar to Power Pivot, SSAS)
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 (2)
RE: Allow Power BI Desktop to Create Perspectives (Similar to Power Pivot, SSAS)
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.
RE: Allow Power BI Desktop to Create Perspectives (Similar to Power Pivot, SSAS)
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.