Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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? 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

4 REPLIES 4
lbendlin
Super User
Super User

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
Not applicable

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

 

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 

 

image.png

 

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.

 

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

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors