Forum Discussion
Auto refresh for dashboard and report
If the storage mode is import, there is no automatic page refresh option for reports. You have to click on the refresh button or reload the tab.
FYI - If the storage mode is DirectQuery and if you have dedicated capacity, then you could enable automatic page refresh.
Refer to this link:https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh
So given your answer nandukrishnavs is there a way for a dashboard to get updated without someone actually refreshing the data? What I mean is I recall that with sheets and tableau you don't have to refresh the data on tableau. If someone changes a data point in the underlying data sheet you are connected to (gsheets) that it will be auto reflected in the dashboard without the need for someone to refresh anything. I am curious if ms365 hosted on sharepoint and connecting powerbi to that sharepoint link makes it like tableau…I am not sure if its possible but I was going to research that also