cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
liewchingchen
Regular Visitor

Scheduled Refresh - Azure SQL Database behind VNET

Hi all, we would like to set Scheduled Refresh for our dashboard on PowerBI Pro Service.

 

As far as we know, if the Azure SQL database server is not within a vNet,

it can be done as simple as enable the "Allow access to Azure Services" in the server option and the PowerBI service will be able to connect to it.

 

However, our Azure SQL database server is going to be within a vNet (PowerBI Data Connectivity Mode: Import).

Will the "Allow access to Azure Services" option still work in that case?

If it will not work (we know Direct Query will not work in this case, unless use the gateway with a VM in the vNet),

please advise how can we connect our PowerBI service to the Azure SQL database server.

 

Thank you.

 

2 ACCEPTED SOLUTIONS
GilbertQ
Super User II
Super User II

Hi @liewchingchen 

 

In order for this to work you will need to download and install the Power BI Gateway and configure it to connect to the Power BI Service.

 

The reason for this as far as I understand is that you need the Gateway within your VNET, so it can then communicate with the Power BI Service.


Here are the details on how to achieve this: Set the Azure Relay for on-premises data gateway | Microsoft Docs





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

v-yangliu-msft
Community Support
Community Support

Hi  @liewchingchen ,

1. To configure the plan refresh, you need to configure the gateway and set the credentials of the gateway

You can view the configuration plan refresh here:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

 

2. “Allow access to Azure services”,  your server allows communications from all resources inside the Azure boundary.

When set to ON,other resources within the Azure boundary, for example an Azure Virtual Machine, can access SQL DatabaseThere is another one that has the same function as "allow access to azure services" and is more restrictive: IP firewall rules or virtual network firewall rules

This is a related document:

https://docs.microsoft.com/en-us/azure/azure-sql/database/network-access-controls-overview#allow-azu...

 

3. Related documents of powerbi service connecting to azure SQL database server:

https://www.mssqltips.com/sqlservertip/5953/create-power-bi-connection-to-azure-sql-database/

https://azure.microsoft.com/en-us/blog/securing-the-connection-between-power-bi-and-azure-sql-databa...

 

Best Regards

Liu Yang

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

View solution in original post

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

Hi  @liewchingchen ,

1. To configure the plan refresh, you need to configure the gateway and set the credentials of the gateway

You can view the configuration plan refresh here:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

 

2. “Allow access to Azure services”,  your server allows communications from all resources inside the Azure boundary.

When set to ON,other resources within the Azure boundary, for example an Azure Virtual Machine, can access SQL DatabaseThere is another one that has the same function as "allow access to azure services" and is more restrictive: IP firewall rules or virtual network firewall rules

This is a related document:

https://docs.microsoft.com/en-us/azure/azure-sql/database/network-access-controls-overview#allow-azu...

 

3. Related documents of powerbi service connecting to azure SQL database server:

https://www.mssqltips.com/sqlservertip/5953/create-power-bi-connection-to-azure-sql-database/

https://azure.microsoft.com/en-us/blog/securing-the-connection-between-power-bi-and-azure-sql-databa...

 

Best Regards

Liu Yang

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

View solution in original post

GilbertQ
Super User II
Super User II

Hi @liewchingchen 

 

In order for this to work you will need to download and install the Power BI Gateway and configure it to connect to the Power BI Service.

 

The reason for this as far as I understand is that you need the Gateway within your VNET, so it can then communicate with the Power BI Service.


Here are the details on how to achieve this: Set the Azure Relay for on-premises data gateway | Microsoft Docs





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors