Published dashboard showing duplicates - developer mode not showing duplicates

[pammmii]

Hello,

I am having issues with my API connection in Power BI. 

The API is connected to a report on our CRM. My users are having issues on the published dhasboard, where they see duplicate firm rows, the duplicate firms are the firms that were modified/updated that day in our CRM. 

On the developer mode, I do not see these duplicates. They are only shown on the publisheddashboard. 

They go away when I do a manual refresh on the developer side and republish the dahsboard.

We have incre

[Anonymous]

Hi @pammmii ,

Did you configure the schedule refresh for the dataset in Power BI Service? How about doing manually refresh to get latest data?

Solved: Automatically refresh online data (CRM) in Power B... - Microsoft Power BI Community

How to update a Power BI Dashboard automatically in Dynamics 365 CE CRM

Best Regards,
Eyelyn Qin

[pammmii]

Hi @Anonymous,

I have set up scheduled refresh for almost every hour. That is when the duplicates show up.

I can remove the duplicates when I re-publish the data from the developer Power BI platform.

Thank you, 

[otravers]

Typically duplicates happen with incremental refreshes when filtering with >= RangeStart and <= RangeEnd. One of these conditions need to be strict.