11

Managing the On-Premises Data Gateway

For many organizations, the data sources for Power BI datasets or reports are located in on-premises environments. The on-premises data gateway (gateway) serves as a bridge between the Power BI service and on-premises data sources, providing a means to securely connect to these sources to support scheduled data refreshes. In the case of DirectQuery and Analysis Services Live connections, the gateway is used to return the results of queries requested by users in the Power BI service.

As a critical component of many Power BI solutions and potentially other solutions utilizing Microsoft cloud services, such as Azure Analysis Services, Power Automate, and Power Apps, a sound understanding of the data gateway ...

Get Mastering Microsoft Power BI - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.