Secure Report Refresh

[Grins]

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. 

[v-binbinyu-msft]

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.

[Grins]

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

[v-binbinyu-msft]

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.

[Grins · 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