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