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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors