Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.