Forum Discussion
Pbirs auto refresh MySQL
Hi eRic_LaU
Since your MySQL data, Power BI Report Server (PBIRS), and SQL service are hosted within the same local network, you do not need an on-premises data gateway for data refreshes. The gateway is typically required when connecting to cloud-based data sources or external systems. Since the connection to MySQL in PBIRS is already tested and successful, the issue likely lies elsewhere. First, double-check the credentials used for the scheduled data refresh in PBIRS, ensuring they are correctly configured and have sufficient permissions to access the MySQL database. Additionally, ensure there are no issues with the firewall or network settings that might block communication between PBIRS and MySQL. If the credentials are fine, inspect the PBIRS logs for any errors related to the refresh process, as they may provide insight into why the refresh completes but no data is updated. Another useful test is to manually refresh the dataset in PBIRS to see if the issue is isolated to the scheduled refresh configuration. If the manual refresh works, the issue might lie in the scheduled refresh settings or configuration. Lastly, verify the connection string used in Power BI Desktop and ensure there are no discrepancies with the settings in PBIRS. By following these steps, you should be able to identify the underlying cause and resolve the issue preventing the data from being updated during scheduled refreshes.
Hi eRic_LaU
If your scheduled data refresh in Power BI Report Server (PBIRS) shows as "Completed Data Refresh" but no data is actually updated, it could be due to a misconfiguration in the data source connection or credentials. First, ensure that the credentials for your MySQL data source are correctly set up in PBIRS and have the necessary permissions to access the database. If you're using an on-premises MySQL server, make sure an on-premises data gateway is installed and properly configured, as PBIRS will need this to refresh data from an on-premises source. Also, verify that the connection string in Power BI Desktop is correct and test it to ensure successful connectivity to MySQL. If the refresh still doesn't work, check the PBIRS logs for any errors during the refresh process, as they can provide further insights into the issue. Additionally, try a manual refresh within PBIRS to see if it successfully updates the data; if it does, the issue may be with the scheduled refresh configuration. By following these steps, you can identify and resolve the root cause of the problem with your data refresh.
Hi Poojara_D12
Thanks for your reply, The data source connection/credentials in pbirs was tested and connection OK.
MySQL data, pbirs & sql service all host at the same local network. Data gateway still required? If Yes How do i setup, If NO what i have miss to enable the refresh.
Hi eRic_LaU
Since your MySQL data, Power BI Report Server (PBIRS), and SQL service are hosted within the same local network, you do not need an on-premises data gateway for data refreshes. The gateway is typically required when connecting to cloud-based data sources or external systems. Since the connection to MySQL in PBIRS is already tested and successful, the issue likely lies elsewhere. First, double-check the credentials used for the scheduled data refresh in PBIRS, ensuring they are correctly configured and have sufficient permissions to access the MySQL database. Additionally, ensure there are no issues with the firewall or network settings that might block communication between PBIRS and MySQL. If the credentials are fine, inspect the PBIRS logs for any errors related to the refresh process, as they may provide insight into why the refresh completes but no data is updated. Another useful test is to manually refresh the dataset in PBIRS to see if the issue is isolated to the scheduled refresh configuration. If the manual refresh works, the issue might lie in the scheduled refresh settings or configuration. Lastly, verify the connection string used in Power BI Desktop and ensure there are no discrepancies with the settings in PBIRS. By following these steps, you should be able to identify the underlying cause and resolve the issue preventing the data from being updated during scheduled refreshes.