Forum Discussion

saranrajk's avatar
saranrajk
Helper II
6 years ago

How to access power BI ssas instance programmatically

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
General Comment
Need Help
Tutorial Requests
v-yingjl's avatar
v-yingjl
Community Support
6 years ago

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-analysis/td-p/694727
  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's avatar
saranrajk
Helper II
6 years ago

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.