Power bi data discrepancy

[Atl]

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.

[Anonymous · Accepted solution]

@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

[Atl]

Bumping for visibility 

[amitchandak]

@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]

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.