PowerBI doesn't Refresh

Question

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.

Answer 1

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.