Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
tonyfreitas
New Member

share gateway for external user and database

Hello!

 

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?

1 REPLY 1
v-yulgu-msft
Microsoft Employee
Microsoft Employee

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.

 

Regards,
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

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.