Forum Discussion
Atl
Helper I
Helper IPower 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...
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
AtlHelper I
Helper IBumping for visibility