Forum Discussion
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
3 Replies
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:
- https://community.powerbi.com/t5/Desktop/Difference-between-Import-and-Connect-live-a-SQL-Server-analysis/td-p/694727
- 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:
- https://docs.microsoft.com/en-us/power-bi/desktop-analysis-services-tabular-data
- 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.
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.
