Direct Query - how does it refresh when embedded in Sharepoint?

[Anonymous]

Can someone explain.. I have a Power BI report that has  both import and direct query data sources. The Direct Query needs to be the latest data always when a user looks at it. Users are accessing it in SharePoint. Since there's no refresh button on sharepoint, does it still know that it needs to pull the latest data when a user opens the sharepoint page that has the report on it?

[GilbertQ · Accepted solution]

Hi there Every time a user interacts with a report page that has got a DirectQuery it will fire off the query to the source and then render the results. Depending on how it is set up it might have to be refreshed for the entire page to see the latest data on the report page. The dashboard tiles can be configured for auto refreshing but not the report pages unfortunately.