- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What is the refresh cadence of an import mode dataset (a report created in the service)
So the scenario is:
A dataset (import mode) is published to the service. A report author connects to this dataset in the service to create a report.
At the end of the day, the dataset is refreshed manually, and re-published back to the service.
What type of "connection" is created when a report is created in the service? Does the user have to refresh their report to see the updated information, or will this happen automatically? Does it matter what storage mode was used to create the dataset?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No, doesn't matter. Once a dataset is refreshed (or more accurately, replaced, with old data blitted out and new data blitted in) it will be available for consumption. However, what happens next depends on the client.
Dashboard: will automatically update its visuals
Report: will update only when there is user interaction (change of filters for example) or when the report has automatic page refresh enabled.
So if a report user looks at the report URL, and then you refresh the dataset (in whatever way), the report will NOT update for that user until the user takes action that forces a re-render.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No, doesn't matter. Once a dataset is refreshed (or more accurately, replaced, with old data blitted out and new data blitted in) it will be available for consumption. However, what happens next depends on the client.
Dashboard: will automatically update its visuals
Report: will update only when there is user interaction (change of filters for example) or when the report has automatic page refresh enabled.
So if a report user looks at the report URL, and then you refresh the dataset (in whatever way), the report will NOT update for that user until the user takes action that forces a re-render.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@lbendlin Thanks for this. Does this also apply to Mixed mode reports? And does auto page refresh apply to Mixed mode as well? Our power bi admin just enabled that at the tenant level, but I don't see this option in any reports, and I don't see it in the preview options.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous ,
Automatic page refresh supports mixed mode (DirectQuery + other data sources). But if your visuals reference Import tables, automatic page refresh isn't supported.
For more information, please refer to Automatic page refresh in Power BI
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If your datasource is Direct Query then the behavior is slightly different. it will rely much more on the user interaction for reports. Dashboards are supposed to refresh periodically (every hour?) but that seems to be unreliable.
Automatic page refresh can only be enabled for Direct Query datasets, I don't know how it will behave in mixed datasets (or if it will be available at all)

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-02-2024 11:26 PM | |||
05-27-2024 09:10 AM | |||
01-23-2024 02:32 PM | |||
03-22-2024 03:22 AM | |||
08-08-2024 07:43 AM |