Forum Discussion

Atl's avatar
Atl
Icon for Helper I rankHelper 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 from sql database and another power bi dataset which is direct query mode are matching exactly. Discrepancy is not following any pattern. Discrepancy would be consistent and major if transformations or relationships or incremental refresh settings were wrong. 
 
All category dataset which is import mode and has incremental refresh
Store number Business week    item gl category     Sum of margin amount
       63                 3/4/2024                Hot food                    $1290
 
SQL database
Store number Business week    item gl category     Sum of margin amount
       63                 3/4/2024                Hot food                    $1268
 
All category dataset which is direct query mode
Store number Business week    item gl category     Sum of margin amount
       63                 3/4/2024                Hot food                    $1268
 
Please help. thanks in advance.
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

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper 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
      Icon for Helper I rankHelper 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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    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