Strategy for the Data Gateway Connection to our Data Warehouse

Hi, hs28 

Implement RBAC to ensure that users only have access to the data they are authorized to view. You can create different roles in your data warehouse and assign them to users based on their access needs. Instead of using a single powerful service user, create multiple connections with different access levels. This allows users to connect to the data warehouse with credentials that provide only the required access to the data.
You can also use an on-premises data gateway in Enterprise mode, which supports live connections and DirectQuery operations. This allows the gateway to be centrally managed and monitored, ensuring better security and control. You can check the following link:

Power BI usage scenarios: Managed self-service BI - Power BI | Microsoft Learn

Or take advantage of Power BI dataflows and data marts to preprocess and store data to share necessary data in a more controlled way to limit data exposure. You can check this link:

Connect to cloud data sources in the Power BI service - Power BI | Microsoft Learn

Use parameterized queries to limit the returned data based on user input, ensuring that users can only retrieve the data they are authorized to view. Implement audits and monitoring to track who is accessing what data, helping you quickly identify and resolve any unauthorized access.

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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