cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Cathryn Member
Member

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


Cathryn

3 REPLIES 3
Moderator v-yuezhe-msft
Moderator

Re: Connect to Datasets in PowerBI via SSMS

@Cathryn,

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.

http://blogs.adatis.co.uk/simonwhiteley/post/PowerBI-Optimisation-1-Connecting-Via-Management-Studio

Regards,
Lydia

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.
AlexisOlson Member
Member

Re: Connect to Datasets in PowerBI via SSMS

@v-yuezhe-msft 

 

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.

cyrjulien New Member
New Member

Re: Connect to Datasets in PowerBI via SSMS

Hi @Cathryn 

 

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

Here the documentation: https://docs.microsoft.com/en-us/power-bi/service-premium-connect-tools.

 

Enjoy

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 437 members 4,221 guests
Please welcome our newest community members: