Forum Discussion

Atl's avatar
Atl
Helper I
2 years ago
Solved

Power bi data discrepancy

Hello everyone, All category dataset which is import mode and has incremental refresh is showing incorrect data only sometimes and only for some categories and slight discrepancy . Data directly fro...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    amitchandak Thanks for your contribution on this thread.

    Hi Atl ,

    Direct Query mode establishes a live connection to the underlying data source, ensuring that the data displayed is always current. On the other hand, Import mode loads data into Power BI’s memory, providing a snapshot of your data at a specific point in time during the data refresh. If the data in your SQL database changes after the data refresh in Power BI, it could lead to discrepancies. You can try to refresh the data in Power BI and see if the discrepancy still exists.

    Power BI Import vs Direct Query: Everything You Need to Know 

    Best Regards

amitchandak's avatar
amitchandak
Super User
2 years ago

Atl , Please check the incremental logic, if that on a date like the updated date, it might not work. Power BI will delete and insert not update and insert. You should use date like create date, billing date etc

  • Atl's avatar
    Atl
    Helper I
    2 years ago

    Hi amitchandak , thank you for your help. please help me understand. Discrepancy would be consistent and major if incremental refresh settings were wrong correct? In my case Discrepancy is very minor and only happening on very few dates and only happening on 3 different item category out of 12. this is very random and not consistent across.