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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
mamaHani
New Member

how to specify the perspective in the connection string while connecting model deployed to powerbi

hello

is there a possibility to specify the perspective in the connection string while connecting to semantic model that was deployed to powerbi workspace?

i found this docs

https://learn.microsoft.com/en-us/power-bi/paginated-reports/report-data/data-connections-data-sourc...

when i connect i go via Get Data -> More -> Azure -> Azure Analysis Services database 

then in the popup i enter the connection link into server and the model name into the database

after that a popup comes up where i can select on the screen the perspective to which i want to connect

however id like to enter  perspective into the connection string either in the server box or database box

is this possible?

rgds

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @mamaHani ,

Based on the description, you can enter perspective you want to connect to in Database.

vjiewumsft_0-1727315248075.png

vjiewumsft_1-1727315284320.png

You can view the following document to learn more information.

Learn how to connect to Azure Analysis Services with Power BI | Microsoft Learn

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
dpFr33
Advocate II
Advocate II

Hi,

The perspectives are only working with Analysis Servives connexion, not with Power BI Semantic Model connexion.
The perspective can help users to understand complex model (multiple star schemas).
There's an idea to add a combo box selector in Power BI Desktop "Data": Please vote 
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=ff2e885c-569a-4cbf-837a-1ea0b10f96e1


Regards,
Denis

ttps://ideas.fabric.microsoft.com/ideas/idea/?ideaid=ff2e885c-569a-4cbf-837a-1ea0b10f96e1

Regards,
Denis

You can create perspectives on Semantic Models  via Tabular Editor.

 

The OP question was how to select a perspective in the connection.

Anonymous
Not applicable

Hi @mamaHani ,

Based on the description, you can enter perspective you want to connect to in Database.

vjiewumsft_0-1727315248075.png

vjiewumsft_1-1727315284320.png

You can view the following document to learn more information.

Learn how to connect to Azure Analysis Services with Power BI | Microsoft Learn

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin
Super User
Super User

Doesn't look like it

 

Perspectives in Analysis Services tabular models | Microsoft Learn

 

Once you connected, have a look at the Connections dialog, see if anywhere in the stored connection string is there any mention of the perspective you chose.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.