Power BI Data Gateway - Cloud Service

[Anonymous]

Hi, 

To one of my customer I have created some Power BI reports and uploaded to the on-premise report server. The data source are connected to another on-premise SQL server.

Now they need the report in cloud server and for that I have installed the required Power BI data gateway and configured to connect SQL Server. 

The customer security team questions me in which format the data gateway sends the information to Power BI reports in cloud service. Whether it will convert to XML or JSON or any other format. Can anyone answer me ?

[v-yingjl · Accepted solution]

Hi @Anonymous ,

Refer the gateway architecture first: On-premises data gateway architecture 

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. The gateway cloud service analyzes the query and pushes the request to Azure Service Bus. Service Bus offers a reliable and secure platform for asynchronous transfer of data and state.

Data is transferred between different applications and services using messages. A message is in binary format and can contain JSON, XML, or just text. For more information, see Integration Services white paper.

Best Regards,
Yingjie Li

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

[vanessafvg]

try looking through these white papers

https://docs.microsoft.com/en-us/power-bi/guidance/whitepaper-powerbi-security
https://aka.ms/PBIEnterpriseDeploymentWP

you should be able to find what you looking for.

[nandukrishnavs]

@Anonymous 

All data requested and transmitted by Power BI is encrypted in transit using HTTPS to connect from the data source to the Power BI service. A secure connection is established with the data provider, and only once that connection is established will data traverse the network.

Refer to this

https://docs.microsoft.com/en-us/power-bi/guidance/whitepaper-powerbi-security

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-indepth