Incorrect value shows in table, and duplicate row while exporting from Service

[Chipsnump]

Hi,

I get this correct results for the first time - then I published immediately

after 20 mins, without forcing any Refresh it turns to 

While I try to force refresh and get back the first value. It cannot do though. The source files locates in internal share drive.

Publish version, although the summarize value is correct, but exporting the file, there're lots of duplicate which desktop doesn't have.

Please help and advice. I faced with this issue for a week (Nov2024 Version)

[Bipin-Lala]

Hi @Chipsnump,

Power BI visuals show aggregated data, but exports often include the underlying, non-aggregated data, leading to differences. Also, exported data may not honor visual level filters or slicers applied in the report visuals.

Also, a lot of the times, incorrect model relationships does lead to duplications. Do check for those.

If this doesn't amswer your question, can you share some more details about your data/ model or if the data is not sensitive, share your pbix file, which would help everyone with the investigation.

Let me know if you have any questions!