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.
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
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
@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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.