How to access power BI ssas instance programmatically

[saranrajk]

Hi,

I'm trying to access ssas instance of power BI desktop, I can access it using SSMS, can any one please help me with this.

Regards,

Saranraj Kumar

[v-yingjl]

Hi @saranrajk ,

You can connect to SSAS in power bi desktop by these steps:

Home -> Get data -> Analysis Services -> enter your server name (database name is optional) -> choose Import or Connect Live mode -> OK.

About differences between import or connect live mode when connecting to SSAS in power bi desktop, please refer the following Microsoft case and document that could help you:

1. https://community.powerbi.com/t5/Desktop/Difference-between-Import-and-Connect-live-a-SQL-Server-ana...
2. https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery

More details about SSAS in power bi desktop, please refer the following Microsoft documents that could help you:

1. https://docs.microsoft.com/en-us/power-bi/desktop-analysis-services-tabular-data
2. https://docs.microsoft.com/en-us/power-bi/desktop-ssas-multidimensional

Best Regards,

Yingjie Li

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

[saranrajk]

Hi ddin't mean to access to SSAS through power BI,

Power BI creates an SSAS instance once we open it and uses  it, folder we like below

C:\Users\user\Microsoft\Power BI Desktop Store App\AnalysisServicesWorkspaces\AnalysisServicesWorkspace171096645\Data

I can it by using the port nnumber this instance using SSMS, can anyone tell me that how to access it programmatically.

[amitchandak]

 This can help

https://www.ironsidegroup.com/2019/05/21/power-bi-ssas-tabular-modeling-essentials/

https://www.youtube.com/watch?v=7FgCfnjteuM

https://www.youtube.com/watch?v=pX-Pyho1cnE

https://docs.microsoft.com/en-us/power-bi/desktop-analysis-services-tabular-data