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

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