MBAS How to configure a Gateway to On-Prem SQL Ser...

Anonymous · ‎05-08-2020

MBAS How to configure a Gateway to On-Prem SQL Server for a Power BI Premium Capacity?

Greg_Deckler · ‎05-08-2020

https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎05-08-2020

Thanks Greg - but your example is for a PowerBI report connected to an On-Prem SQL Server. My question was for the latest new feature (from last month) of the XMLA Endpoint on the Premium Capacity - once deployed (by lifting an On-Prem SSAS XMLA model to Premium) - how to now refresh the Premium model via a gateway to an On-Prem SQL Server (like the original On-Prem SSAS model was doing via direct connect).

MBAS How to configure a Gateway to On-Prem SQL Server for a Power BI Premium Capacity?

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024