Showing results for 
Search instead for 
Did you mean: 
New Member

share gateway for external user and database



have a web application with several users of different companies. I would like to provide customers with access to the bank so that each one can create their report and publish it on the internet. In this scenario each client has its database, client1 bank BD1, client2 bank BD2, all banks are configured on single SQL server. With the power bi gateway, can I restrict client access so that everyone can view only their database?


Hi @tonyfreitas,


The data gateway acts as a bridge, providing quick and secure data transfer between on-premises data and the Power BI, Microsoft Flow, Logic Apps, and PowerApps services. It cannot be used to set role security to grant specific DB access for specific users.


Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Kudoed Authors