Duplicate records in thin report but not in the dataset

[calerof]

Hello,

Does anyone have experienced duplicate records in the thin report but they are not duplicated in the dataset?

My data source is a Dataverse table from a Power Platform Dataflow.

When I refresh the dataset manually, publish to the service and open the thin report, it appears correct, without duplicates. But at the next scheduled refresh, there they are, duplicate records. 

I find this really strange and can't come up to a reason why.

Thanks,

Fernando

[amitchandak]

@calerof , Check if there is any issues in joins(tables) and that is causing duplicates

[calerof · Accepted solution]

Hi @amitchandak,

Thank you for your response. I did some changes, basically I had a Purchasing fact table joined with a Material Master dimension table as Left Outer. I changed it to Right Outer, so all the records from the Material Master will be considered. Then I updated all the tables and the duplication went away. I refreshed manually all tables a couple of times to verify and it still comes without duplicates. Let me wait for a normal business day to check again, and I'll close this thread as accepted.

Thanks!

Fernando

[calerof]

Who accepted my comment as a solution? It's not resolved and my comment is not the solution. I still have duplicates after having done the procedure I mentinoed above.