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 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.