Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Secure Access to Azure SQL Servers for Power BI

Looking for a secure way to consume data from our Azure SQL Database as a services to our Microsoft cloud PowerBI environment, I found 2 blog posts. 1 from 2018 and one(telling the same) from 2020; ...
Data Protection
Tips and Tricks
Tutorial Requests
selimovd's avatar
selimovd
Most Valuable Professional
4 years ago

Hey Anonymous ,

 

depends how you define "secure access".

 

You don't need a VM to connect Azure SQL to Power BI. You can just activate the "Allow Azure services and resources to access this server" check box and Power BI Services can connect directly to your Azure SQL Server:

 

After you check this box, all Azure services would be allowed to connect to the SQL Server, but you still need access or credentials to log in to the Server.

In the blog articles they want to limit the traffic, that only Power BI can connect to the database and not all Azure resources and services. For that special setup you need a VM and a data gateway.

But for a normal access you don't need to do any of that.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis