Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
Ref: Let users personalize visuals in a report - Power BI | Microsoft Learn
In our old multidimensional SSAS setup it was possible to create perspectives that would limit the view on which tables/columns one would be able to see. This was handy since the main tool used by business to explore this is Excel and there when trying to connect they had to first pick a perspective before they would be able to plot the data. The data connector chosen was "from database/From Analysis Services" where you would be able to directly select the required perspective. But it seems you cannot get to a proper way of authenticating since we use Azure Active directory.
However in Power BI this seemed impossible since the main connection you would use to connect to a Power BI data set is well ... a Power BI dataset which does not seems to offer a possibility unless you would connect and then afterwards would specify the perspective explicitly in the data source settings:
Solved! Go to Solution.
To come back to this, I found out you can still do it the old/multidimensional way, but the crux lies in the authentication which is confusing.
You can ignore the PowerPlatform options and instead choose:
Then we need to paste the following server name and choose “log on credentials - user name/password”.
These fields you can leave empty and click next where you will be prompted to confirm you AAD identity.
After this you'll have the option to choose the model or perspectives:
To come back to this, I found out you can still do it the old/multidimensional way, but the crux lies in the authentication which is confusing.
You can ignore the PowerPlatform options and instead choose:
Then we need to paste the following server name and choose “log on credentials - user name/password”.
These fields you can leave empty and click next where you will be prompted to confirm you AAD identity.
After this you'll have the option to choose the model or perspectives:
@Amit well I might have posted this in the wrong location, but it's not a question rather it's a tip. The situation above handles the situation when you already added perspectives with Tabular Editor. So while I appreciate your feedback I have a bit of the feeling you did not properly read the content. Cheers
@PaginatedDino , You need tabular editor for that
https://data-marc.com/2020/08/18/power-bi-visual-customization-using-perspectives/
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
56 | |
56 | |
38 | |
29 |
User | Count |
---|---|
75 | |
62 | |
45 | |
40 | |
39 |