Data Model Refresh Issue on Power BI Service - No Data Added After Refresh

[likvors_husband]

Hi everyone,

I’m facing an issue with my Power BI data model hosted on the Power BI Service. The model connects to two data sources:

1. A MySQL instance hosted in Google Cloud via a direct connection (no ODBC).
2. A different MySQL database, also hosted in Google Cloud, accessed through an ODBC connector.

I’m using an on-premises data gateway to manage these connections.

When I attempt to refresh the data model on the Power BI Service, the refresh process completes without any errors, but no new data is added to the model. However, when I download the .pbix file and refresh it locally using the Power BI Desktop app on my PC, the new data appears as expected.

Interestingly, the MySQL database connected via the ODBC connector does refresh properly on the Power BI Service, and new data is reflected in the model. The issue seems isolated to the MySQL connection that does not use the ODBC connector.

Additionally, I’ve tried connecting directly to Google Analytics 4 using the Power BI connector, without any interim data storage (so bypassing the MySQL), and encountered a same problem: no new data on service is added after the refresh, and no errors are shown. For desktop app it works

Has anyone else encountered this issue or have any suggestions on how to resolve it? Any insights would be greatly appreciated!

Thanks in advance!

[likvors_husband]

Thank you

[lbendlin · Accepted solution]

Go through your Power Query code again and check for any filters that you may have forgotten about.

Also - create a new PBIX that only queries a single table on the MySQL server "directly"  (hate to break it to you but that is also a -hidden- SIMBA ODBC driver).  Then change that table and see if the change comes through.