Forum Discussion
Datamart Often Showing Wrong Numbers
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 What are you using to ingest data? Python notebook? Azure Data Factory? Dataflow?
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.