Refresh data problem

[Sorin_Guzu]

We have an PowerBI report developed on PowerBi Desktop (May 2020) (Version: 2.81.5831.1181 64-bit (May 2020)), like on following figure.

Data source, data feeding, it’s made by precise mysql database query (mysql db it’s on-prems server). The information loaded on PowerBI are: “Tag_description”(Varchar), “Tag_value”(decimal 15,5), “Tag_time_value”(timestamp). Data base it’s frozen, each tag having values between 2022-05-07 00:00:00 and 2022-05-11 23:59:59.
The verification on data accuracy displayed on PowerBi Desktop versus data from mysql data base (data source), is 1:1 (the same). The comparison performed it’s related with: number of recordings for each tag (mysql vs. PowerBi Desktop), time frame for each tag (mysql vs. PowerBi Desktop), values obtained after querying mysql DB by sum or average versus values displayed on PowerBi Desktop. After comparison, the data from the PowerBi Desktop and mysql db are idencical.
The PowerBi model report it’s saved and loaded on the reporting system PowerBi server (Version: 15.0.1103.234).
The refresh plan (Schedule refresh) it’s configured for the report model saved on server. For the data refresh on server the schedule was set to run daily at a certain time.
After the schedule refresh is executed, the displayed data on report (server) is incorrect. Below can be seen the result after run the schedule refresh on server.

By comparing the desktop and server versions, there are differences in the displayed values and the number of records as follows:
-a new record appears in the table, with various values in all columns, corresponding to the date of May 6 (we should not have found records for May 6, in addition we do not have the date for May 6 in the records received from the database),
-the columns “Homogeneous dosing A + B”, “Homogeneous dosing A”, “Homogeneous dosing B”, “Temperature…”, “Machine 5 speed…”, “Machine 6 speed…” have altered values (they do not correspond to the values found in database within the displayed time range),
- the columns “M5 utilization rate” and “M6 utilization rate” have the values shifted a day ago, the values are unaltered but displayed incorrectly on the date.

What can be the problem?

Thx

[v-yetao1-msft]

Hi @Sorin_Guzu 

Can you make sure that the datasets involved in your report do not contain other data sources ? Have other filter conditions been set in the report on your Service, causing the results to be inconsistent with those on the Desktop ?  You manually refresh the Service and Desktop at the same time, are the displayed results the same ? 

Best Regards,
Community Support Team _ Ailsa Tao

[Sorin_Guzu]

Hi @v-yetao1-msft 

My answear:

1. Can you make sure that the datasets involved in your report do not contain other data sources ?

R:  Datasets involved in my report contain only mysql data sources. There are distinct mysql databases (on the same environment) from where the data is loaded. On the mysql statements in PowerBi have been put a filter for time frame between 2022-05-07 00:00:00 and 2022-05-11 23:59:59, in order to load the values for tags on specified time frame.

2. Have other filter conditions been set in the report on your Service, causing the results to be inconsistent with those on the Desktop ? 

R:  The report models are the same Service vs. Desktop. The report model from Desktop were saved on Service.

3. You manually refresh the Service and Desktop at the same time, are the displayed results the same ?

R:  After manually refreshing Service and Desktop at the same time, the results displayed are different (as I mentioned, please see the printscreens on first post).

Best regards,

Sorin