Forum Discussion
Query Regarding Power BI schedule Refresh
Hello Subrat2581 ,
if you're accessing a db through vpn , then you're right as you mentioned you'll need a server 24/7 that has internet and a gateway so it would refresh with service.
Your solution is so great Idrissshatila
Hi, Subrat2581
For Windows systems, you can follow the article below to set up 24x7 operation.
How do I keep my display on 24/7 - Microsoft Community
If Idrissshatila answers your original question, you can accept it as a solution so that others will know that the question has been answered and help other people in the community. Thank you again for participating!
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Subrat2581 -
If your Azure-hosted MySQL database is publicly accessible (i.e., has a public IP address and is not restricted to specific on-premises networks), you do not need a gateway. Power BI Service can connect directly to the database over the internet.
If the database is behind a private network (e.g., secured within a virtual network or accessible only from an on-premises environment), a gateway will be required to bridge the connection between Power BI Service and the database.
Steps to Configure Scheduled Refresh
Publish the Report:
After creating and testing your dashboard in Power BI Desktop, publish it to Power BI Service.
Set up a Data Source Connection:
Go to the dataset in Power BI Service.
Navigate to Settings > Dataset > Data source credentials.
Configure the connection to the Azure-hosted MySQL database:
Choose the appropriate authentication method (usually basic with a username and password).
Ensure the connection test passes.
Enable Scheduled Refresh:
In the same Settings > Dataset menu, go to the Scheduled Refresh section.
Enable Keep data updated.
Set the frequency of the refresh (e.g., daily, hourly).
Specify the time zones and refresh windows as needed.
Using a Gateway (if required):
If your database is private, install and configure an On-premises Data Gateway on a machine that has network access to the Azure-hosted MySQL database.
Add the data source in the gateway settings, matching the credentials used in Power BI Desktop.
Ensure that the connection from Power BI Service to the Azure-hosted MySQL database is tested frequently to avoid refresh failures.
Alerting: Configure email notifications in Power BI Service to alert you in case of scheduled refresh failures.
Hope the above details give a clarity
So that means I need a local system to be connected 24X7 to the internet so that the bridge is maintained between DB & Power BI service for scheduled refresh, if my local system fails to connect with DB then the schedule refresh will also fail.
Please suggest if there are any chnages in my view
