On-Premises Data Gateway

(0) Share

Report

Posted on by AH-30070814-0

When using the On-Premises Data Gateway for a PowerApps-based application to connect a SQL Server hosted on a local server, is any data stored in the cloud, or is it only transferred securely through the gateway?

Categories:

Authentication

I have the same question (0)

All responses (1)

Answers (0)

stampcoin 4,082 Super User 2025 Season 2 on at

Like (0)

Report

On-Premises Data Gateway

@AH-30070814-0 Hi,

You can check this article and related topic.

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem-indepth#how-the-gateway-works

It mentions that "queries like Power BI and Azure Analysis Services refreshes can return large amounts of data. For such queries, data is temporarily stored on the gateway machine. This data storage continues until all data is received from the data source. The data is then sent back to the cloud service. This process is called spooling. We recommend you use a solid-state drive (SSD) as the spooling storage.".

Was this reply helpful? Yes No