Have multiple people connect to Azure SQL database with Power BI Desktop

[PunchBird]

Hi,

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 I can whitelist. Any suggestions on how to resolve this?

Thanks!

[PunchBird · Accepted solution]

I found out there is not much you can do. Suggested is to create a new database at the beginning of the course, create one user for the students, open all IPs and delete the database at the end of the training.