Power Bi report values not matching with backend query results

[kalyani_bang]

Hi, 

Recently, while testing i got a issue. In power bi report, visual values are not maching with the backend values when i run a query on Test environment. But if i run the same query on dev environment , values in power bi report are matching with backend. Why is it so? If you have any idea please help me with this.

[v-yueyunzh-msft]

Hi , @kalyani_bang 

According to your description, you said that "Power Bi report values not matching with backend query results".

Are the backend query results you mean your data source?

 If your dataset is import mode, then your data is saved in the dataset, which has nothing to do with the data of your data source, and the data displayed in the report is directly queried to the dataset without querying your data source.And the dataset of import mode needs to be refreshed to get the latest data of the data source, you can go to the dataset to check whether your data is the latest data.

If your dataset is Direct Query or Live Connection, then the query in your report is sent directly like a query in the data source, usually showing the latest data. But for Power BI reports there is a browser cache, you need to click "Refresh" in the upper right corner or configure auto page refresh to refresh the report, so that you can get the latest data.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly