Forum Discussion
Published dashboard showing duplicates - developer mode not showing duplicates
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
3 Replies
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 QinHi 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,
Typically duplicates happen with incremental refreshes when filtering with >= RangeStart and <= RangeEnd. One of these conditions need to be strict.
