Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Connect to Datasets in PowerBI via SSMS

Hi everyone


I just saw a webinar that showed SQL Server management studio connected to a PowerBI dataset using an API.  I can't find any documentation on how to do this.


Does anyone have a link that they could share?


Thank you


New Member

Hi @Cathryn 


It's possible to connect directly to your Power BI Premium Workspace using SSMS.

Here the documentation:





Are you looking for the following blog? You are able to connect to Power BI data model from SSMS as Power BI Desktop starts a SQL Server Analysis Services processes in the background, you are actually connecting to a tabular instance from SSMS.


Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



Is it possible to connect to a Power BI dataset that's in the online service rather than locally via Power BI Desktop?


I have datasets in a premium capacity in the cloud and I'm trying to figure out how to access them via SSMS similar to how I can directly connect to pbiazure:// as an OLAP connection via Power BI Desktop or Excel.

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors