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