Forum Discussion
On-premises Data Gateway - Technical Question
Hi krautrocker,
1,2,3 are correct.#4) If you want to share the report, you share it from the report itself. The users list for the gateway is there to allow more people use your gateway to publish different reports they own.
For your assumptions:
1.) I assume that each user does NOT need to install a gateway on their machine. They simply need to log into their PowerBI account and view reports. Is that correct? The Gateway is just that - a gateway that acts a bridge to the data source, as described in the documentation.[Dimah] This is 100% correct
2.) Do users connect to the actual data source on-premise or do I need to publish the report to my PowerBI site and users connect to the data in the cloud?
[Dimah] Depends which data source and how your report is connected to it. Most cases the refresh query will use the account you used to connect to the data source from Manage gateways->Add data source. But if you're using Analysis Services Live connection, we pass the service account for users looking at the report, and if they have access to the on-prem data source they can see data other wise they won;t. This is special for Live connection on Analysis services only.
Hi krautrocker,
1,2,3 are correct.
#4) If you want to share the report, you share it from the report itself. The users list for the gateway is there to allow more people use your gateway to publish different reports they own.
For your assumptions:
1.) I assume that each user does NOT need to install a gateway on their machine. They simply need to log into their PowerBI account and view reports. Is that correct? The Gateway is just that - a gateway that acts a bridge to the data source, as described in the documentation.
[Dimah] This is 100% correct
2.) Do users connect to the actual data source on-premise or do I need to publish the report to my PowerBI site and users connect to the data in the cloud?
[Dimah] Depends which data source and how your report is connected to it. Most cases the refresh query will use the account you used to connect to the data source from Manage gateways->Add data source. But if you're using Analysis Services Live connection, we pass the service account for users looking at the report, and if they have access to the on-prem data source they can see data other wise they won;t. This is special for Live connection on Analysis services only.
dimazaid Thanks a lot for getting back to me so quickly. It's also great to talk to Microsoft staff. I would be interested in speaking with a partner as well, if they are available to us.
I accept this solution (and will mark it so). Is any data actually stored in the cloud or just transferred securely via the Gateway? Our data security team will want to know the answer to this question.
You're welcome.
Here's a link to the PowerBI security docs: https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-power-bi-security/
