I have several PowerBI reports that don't refresh automatically or whenever I press refresh in the website and I have to use PowerBI desktop app to refresh it manually and then save it or publish it again.
The reports use direct queries in MySQL db and are shown in PowerBI website. BTW, These are the PowerBI reports not dashboards. Also I tried to use Automatic Refresh but it failed every time.
This is a screenshot of Power BI in the web:
When you click the Refresh command, it just expires the cache and reloads it from the data source. So if you have had a scheduled refresh or uploaded a new data set this will enable you to see the updated data.
It will NOT refresh the underlying data source. Data refresh is not done with this button.
If you use online content packs, the data refresh of the underlying data source is determined in the individual content pack.
If you use a PBX with your own data sources, you will need to use the data gateway to schedule data refreshes (or run them manually). Then you don't need to refresh the PIBX in PowerBI desktop and re-publish the file.
Well Microsoft Power BI Provides a way to refresh the data automatically by configuring the schedule Refresh in the Power BI Service. So, that wherever there is updated data in the queue it will automatically refresh the data based on schedule time. Below are steps for configuring the schedule refresh.
Once you click on the button then you can see the new three icons as in the image here.
First and second are for report creation and refresh data. But the third icon is for schedule refresh.
Once you have successfully completed the above steps then your data or report will automatically get refreshed.
