Re: Published dashboard showing duplicates - devel...

pammmii · ‎06-21-2022

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 · ‎06-23-2022

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 · ‎06-28-2022

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 · ‎06-28-2022

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

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals