cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Grins
Frequent Visitor

Secure Report Refresh

Hi,

Can anyone assist me in the best way to achieve the following:

How to automatically refresh Power BI Reports running in the public cloud (Power BI Pro) querying a Synapse dedicated pool located in a secure vnet on a private endpoint, without allowing public access on the Synapse networking settings or compromising on security?

Note, solution aimed at Power BI Pro service and NOT Premuim. 

1 ACCEPTED SOLUTION

Thank you for the response, however this does not solve the problem for me.

 

This article helped me to solve it: https://microsoft-bitools.blogspot.com/2021/09/virtual-network-data-gateway-for-power.html

 

View solution in original post

4 REPLIES 4
v-binbinyu-msft
Community Support
Community Support

Hi @Grins ,

Please try to set the schedule refresh rule in Power BI Service or create a flow with Power Automate to refresh the report or create the script to refresh the report.

For more details, you can read related document: Configure scheduled refresh - Power BI | Microsoft Learn , Refreshing PBI dataset using Power Automate - Microsoft Power BI Community , Datasets - Refresh Dataset - REST API (Power BI Power BI REST APIs) | Microsoft Learn

 

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you very much!! I will work through it and confirm as solution. 

Hi @Grins ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. 

 

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Thank you for the response, however this does not solve the problem for me.

 

This article helped me to solve it: https://microsoft-bitools.blogspot.com/2021/09/virtual-network-data-gateway-for-power.html

 

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Top Solution Authors
Top Kudoed Authors