Datamart Often Showing Wrong Numbers

[Sivasekar_G]

Hi All,

I am using datamart to connect CRM with powerBI. Recent days for only one table (leads table) the values are often showing wrong but after giving manual refresh it's working fine. Why this disconnect? Any idea?

[djurecicK2]

Hi @Sivasekar_G ,

 In case you were not aware, Datamarts are discontinued and removed from workspaces on October 1, 2025.

https://powerbi.microsoft.com/en-us/blog/unify-datamart-with-fabric-data-warehouse/

[Sivasekar_G]

Yes I am aware of this and migrated my database already but I want to check here whether this datamart drop off might one of the reason behind this disconnect? that's why.

[rohit1991 · Accepted solution]

Hi @Sivasekar_G ,

The issue you're experiencing with the leads table in your datamart showing incorrect values until a manual refresh is likely due to data synchronization or refresh timing problems between your CRM system and Power BI. When using Datamart, Power BI relies on scheduled or incremental refreshes to update the underlying data. If the leads table is changing frequently or the refresh is incomplete or delayed, you may temporarily see outdated or partial data. A manual refresh forces a complete pull of data, which is why it resolves the issue.

To fix this long-term, check your refresh schedule, ensure credentials and connections are stable, and consider enabling incremental refresh (if not already) for better performance. Also, review any query dependencies or transformation logic specific to the leads table that might be affecting consistency. Monitoring refresh logs and setting up alerts in Power BI Service can help identify if/when refreshes fail or skip rows.

[Sivasekar_G]

Thanks Rohit. I have created the alerts and incremental refresh but still I was facing the issue and I want to know the reason for that. Your reply helps me to find out the reason and thanks for that.

[Greg_Deckler]

@Sivasekar_G What are you using to ingest data? Python notebook? Azure Data Factory? Dataflow?

[Sivasekar_G]

Hi. I am using Power BI Datamart to ingest data directly from CRM Dynamics 365 via Dataverse. This setup allows me to create an end-to-end self-service data pipeline with built-in transformations, data model, and SQL access without needing to manage external ETL tools like Azure Data Factory or Python Notebooks.

The datamart automatically refreshes data from Dataverse, which simplifies the ingestion process and ensures up-to-date reporting. But due to deprecation of datamart I have now migrated the complete data to Azure data lake storage. Anyway for a month we have to depend on this datamart and that's why I created this query here to gather more information.