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

[mamaHani]

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

[dpFr33]

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

[lbendlin]

You can create perspectives on Semantic Models  via Tabular Editor.

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

[Anonymous · Accepted solution]

Hi @mamaHani ,

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

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]

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.