cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PaginatedDino
Helper I
Helper I

Tip: Perspectives on a big Power BI dataset vs old multidimensional cubes (XMLA enabled only)

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: 

 

PaginatedDino_0-1685439897443.png

PaginatedDino_1-1685440085071.png

 

 

1 ACCEPTED SOLUTION
PaginatedDino
Helper I
Helper I

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:

PaginatedDino_0-1686034906637.png

 

Then we need to paste the following server name and choose “log on credentials - user name/password”.

PaginatedDino_1-1686034943492.png

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:

PaginatedDino_2-1686034998571.png

 

View solution in original post

3 REPLIES 3
PaginatedDino
Helper I
Helper I

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:

PaginatedDino_0-1686034906637.png

 

Then we need to paste the following server name and choose “log on credentials - user name/password”.

PaginatedDino_1-1686034943492.png

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:

PaginatedDino_2-1686034998571.png

 

PaginatedDino
Helper I
Helper I

@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

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors