Forum Discussion
How does Import Query Mode refreshing work?
- 1 year ago
I think the behavior you're observing with up-to-date data in Import mode tables, despite the "last refresh" in Power BI Desktop showing an older date, is likely due to a scheduled refresh in the Power BI Service.
While Import mode datasets require manual or scheduled refreshes to stay current, the refresh schedule configured in the Power BI Service make sure that the data remains up-to-date in the published report, even if it appears outdated in Power BI Desktop.
This discrepancy may happenbecause the "last refresh" in Desktop reflects only local refreshes, not those performed on the service.
Direct Query tables, in the other hand, fetch real-time data directly from the source every time the report is loaded. Another thing, if a refresh schedule exists, the data is likely being updated automatically.
Check this link it can help you Power BI official documentation on scheduled refresh and hybrid datasets to better understand these behaviors and configure your dataset in a better way. If all tables are necessaryfor Import mode, you can improve performance by switching from Direct Query and make surescheduled refreshes are in place.
Your assumpitons about the differences between Direct Query and Import modes are correct.
As far as the Last refresh displayed:
You can build a Power BI model with Import data, save it, and publish it to Power BI service, then set up a refresh schedule for that data. At that point, the data in the saved model is now going stale while the data in the Power BI Service is getting refreshed.
Can you show us a screenshot of the Last Refresh from the Power BI Service?