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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
saranrajk
Helper II
Helper II

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 3
v-yingjl
Community Support
Community Support

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.

ssas.pngssas2.png

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.

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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