Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Refresh issue

Hello, I would like to know that i have deployed one report on service and set powerautomate data refresh flow for every 5 min and set manual refresh as well for 2 times in a day. Now the issue is i ...
  • Akash_Varuna's avatar
    1 year ago

    Hi Anonymous It might be because of discrepancies in handling duplicates between Power BI Desktop and the Service. Ensure your duplicate removal logic accounts for all data variations in incremental refresh settings. Check the data source updates for new records violating uniqueness constraints. Adjust incremental refresh policies to include duplicate checks or reprocess full data as a one-time fix. Validate steps using a staging table or intermediate query to ensure consistency.

  • v-menakakota's avatar
    1 year ago

    Hi  Anonymous  ,
    Thanks for reaching out to the Microsoft fabric community forum. 

    Please go through the below document and solved issue which may help you in resolving the issue:
    https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-troubleshoot

    Solved: Re: Incremental refresh is duplicating the records - Microsoft Fabric Community

    If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
    Best Regards, 
    Menaka.
    Community Support Team.