What is the refresh cadence of an import mode dataset (a report created in the service)

[Anonymous]

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? 

[lbendlin · Accepted solution]

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.

[Anonymous]

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

[v-kkf-msft]

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.

[lbendlin]

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)