Reader small image

You're reading from  Learn Power BI - Second Edition

Product typeBook
Published inFeb 2022
PublisherPackt
ISBN-139781801811958
Edition2nd Edition
Right arrow
Author (1)
Gregory Deckler
Gregory Deckler
author image
Gregory Deckler

Greg Deckler is Vice President of the Microsoft Practice at Fusion Alliance and has been a professional technology systems consultant for over 25 years. Internationally recognized as an expert in Power BI, Greg Deckler is a Microsoft MVP for Data Platform and a superuser within the Power BI community with over 100,000 messages read, more than 11,000 replies, over 2,300 answers, and more than 75 entries in the Quick Measures Gallery. Greg founded the Columbus Azure ML and Power BI User Group (CAMLPUG) and presents at numerous conferences and events, including SQL Saturday, DogFood, and the Dynamic Communities User Group/Power Platform Summit.
Read more about Gregory Deckler

Right arrow

Installing and using data gateways

The on-premises data gateway, or simply data gateway, is a piece of software that's installed on an on-premises computer that provides a secure connection between local, on-premises data, and a variety of services that reside in Microsoft's Azure cloud, including the Power BI service. Once installed, the Power BI service can use this gateway to refresh datasets that have been published to the Power BI service, as shown in the following diagram:

Figure 11.1 – Data gateway

There are two ways the gateway can operate, as follows:

  • Standard
  • Personal

The reason to install a gateway in one mode versus the other comes down to the scenario in which you plan to use the gateway. You will want to use the standard mode if the following applies:

  • You want other users within the organization to use a single, centralized gateway.
  • You need DirectQuery, as well as import mode datasets.
  • You wish...
lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Learn Power BI - Second Edition
Published in: Feb 2022Publisher: PacktISBN-13: 9781801811958

Author (1)

author image
Gregory Deckler

Greg Deckler is Vice President of the Microsoft Practice at Fusion Alliance and has been a professional technology systems consultant for over 25 years. Internationally recognized as an expert in Power BI, Greg Deckler is a Microsoft MVP for Data Platform and a superuser within the Power BI community with over 100,000 messages read, more than 11,000 replies, over 2,300 answers, and more than 75 entries in the Quick Measures Gallery. Greg founded the Columbus Azure ML and Power BI User Group (CAMLPUG) and presents at numerous conferences and events, including SQL Saturday, DogFood, and the Dynamic Communities User Group/Power Platform Summit.
Read more about Gregory Deckler