'How to have multiple people connect to an Azure SQL database via Power BI Desktop?

For a training I would like to have multiple students connect to an Azure SQL database via Power BI Desktop. These students are all over the world so there is no specific IP range or fixed set of IP addresses I can whitelist. Any suggestions on how to resolve this?

Thanks!

sql-serverazureazure-sql-database


Solution 1:[1]

I would recommend you create a single Power BI report using an admin account, and then define Row Level Security in your dataset.

Refer - https://community.powerbi.com/t5/Power-Query/connect-two-different-users-on-same-azure-database-on-the-same/td-p/513463

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 AbhishekKhandave-MT

Related Questions