Forum Discussion
Power BI Report Data Refresh
Hi Anonymous ,
The Import connection mode is to import data into the power bi memory for storage, which is equivalent to a copy and snapshot, so after the database is refreshed, it will not communicate with the database, and we need to manually or plan to refresh.
It is not automatically refreshed with database refreshes, even if scheduled refreshes can be refreshed every minute, but dashboards and reports are not refreshed every minute. The tiles on the dashboard refresh approximately every fifteen minutes.
Direct Query connection mode, everytime we refresh or reload a report that is in a Direct Query mode, Power BI will retrieve the source data from the data source. So when you refresh the dashboard or the report, you will get the latest data. Scheduled refresh of Direct Query is scheduled CACHE refresh.
You can try the following:
- Use Direct Query mode. Refresh the browser tab in a duration you want.
- Use a stream dataset if you want the visual to update in real time.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
This depends a bit on how you are getting the data and potentially could be affected by your license model as well. If you have Direct Query then every time that the report is reloaded then Power BI retrieves the data from teh source and therefore is always the latest data.
You could get streaming or many more refreshes on a schedule if you purchase Premium licensing.
Also, this link might be helpful to read through as well: