Forum Discussion
Issue with Data Discrepancy Between Power Query and Power BI Desktop
Thanks for the reply from Smalfly , please allow me to provide another insight:
Hi, Hadill
Your observation is very astute; however, this is a normal phenomenon.You're observing, but it's normal.
In Power Query, the data preview is merely a snapshot of the displayed data. The actual data loading and application only take effect after you click the “Apply” button. Therefore, just because the data appears normal in Power Query does not necessarily mean that the data loaded into the report will be correct. The data you see in the report view is the final result.
This explains why the data processed in Power Query might differ from the data loaded into Power BI Desktop.
The reason is that the operations performed in Power Query are only a preview until you click the final Apply button, meaning the actual data has not been successfully processed.
Here is a screenshot from the official documentation:
For detailed information, please refer to the following link:
Manage Data Preview (Power Query) - Microsoft Support
Query overview in Power BI Desktop - Power BI | Microsoft Learn
Of course, if you have any new ideas, you are welcome to contact us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Hadill ,
the screenshots of your real case are from 2 different quarters. The first one is from 2024-Q1 while the second one is from 2022-Q4. Could it be that you are looking in the wrong place to validate your data?
That's right, I apologize for the confusion. What I'm trying to highlight is the discrepancy in a different way. On the desktop, it shows that Q1 - 2022 has the highest count/value, while in the actual data (in the data query editor), the highest value is for Q1 - 2024.
Here is the value for Q1 - 2022 in data query view, showing diffrent value than the one on the desktopThanks for the reply from Smalfly , please allow me to provide another insight:
Hi, Hadill
Your observation is very astute; however, this is a normal phenomenon.You're observing, but it's normal.
In Power Query, the data preview is merely a snapshot of the displayed data. The actual data loading and application only take effect after you click the “Apply” button. Therefore, just because the data appears normal in Power Query does not necessarily mean that the data loaded into the report will be correct. The data you see in the report view is the final result.
This explains why the data processed in Power Query might differ from the data loaded into Power BI Desktop.
The reason is that the operations performed in Power Query are only a preview until you click the final Apply button, meaning the actual data has not been successfully processed.
Here is a screenshot from the official documentation:
For detailed information, please refer to the following link:
Manage Data Preview (Power Query) - Microsoft Support
Query overview in Power BI Desktop - Power BI | Microsoft Learn
Of course, if you have any new ideas, you are welcome to contact us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
