PowerBi Desktop and SQL Gateway

Anonymous · ‎03-11-2021

Good morning,

I'm not new to power bi but I am new to Gateway.. I have a simple question...

From Power bi "DESKTOP" can I use my gateway connection ? if yes, how and where...

Power BI is on my PC yes

Gateway is in the cloud Yes

But I'm thinking since Power Bi is connected to my email account via cloud, maybe there is a way to access gateway ...

If Not, what is the process ? Connecting my Power BI Desktop to my server, publish and from there change the datasource to the gateway is that it ?

v-alq-msft · ‎03-15-2021

Hi, @Anonymous

The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services. It depends if you can access the data source.

Here is what happens when you interact with an element that is connected to an on-premises data source.

The cloud service creates a query and the encrypted credentials for the on-premises data source. The query and credentials are sent to the gateway queue for processing. For more information about credential encryption in Power BI, see Power BI security whitepaper.
The gateway cloud service analyzes the query and pushes the request to Azure Service Bus Messaging.
Azure Service Bus sends the pending requests to the gateway.
The gateway gets the query, decrypts the credentials, and connects to one or more data sources with those credentials.
The gateway sends the query to the data source to be run.
The results are sent from the data source back to the gateway and then to the cloud service. The service then uses the results.

For further information, please refer to the following documents.

What is an on-premises data gateway

On-premises data gateway architecture

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.