Is is possible to auto refresh a pbi report stored in sharepoint?

[YC1218]

My report is stored on sharepoint, which means that whenever I save the report on pbi desktop, it is automatically saved on sharepoint. However, I want my reports to automatically refresh once a day, for example, even if I dont save it on desktop, just like it would if I was working with the powerbi service.
I already import the report from the sharepoint to my pbi workspace and set up a scheduled refreshed, however I am under the impression that it would only refresh the semantic model on pbi service, but not on the sharepoint.
My team only uses the report from sharepoint.
(English is not my first language, sorry.) 

[v-dineshya]

Hi @YC1218 ,

Thank you for reaching out to the Microsoft Community Forum.

Hi @GilbertQ  and @Olufemi7 , Thank you for your prompt responses.

Hi @YC1218 ,  could you please try the proposed solutions shared by  @Olufemi7  and @GilbertQ ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.

Regards,

Dinesh

[v-dineshya]

Hi @YC1218 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[Olufemi7 · Accepted solution]

Hello @YC1218, 

No. A Power BI report (.pbix) stored in SharePoint cannot auto-refresh

• A .pbix file in SharePoint is static and only refreshes when opened and refreshed in Power BI Desktop, then saved.
• Scheduled refresh works only in the Power BI Service and refreshes the semantic model (dataset) there.
• That refresh does not update the .pbix file stored in SharePoint.

Microsoft documentation:

• Refreshing files from OneDrive/SharePoint (dataset refresh does not sync back to the file):
  https://learn.microsoft.com/power-bi/connect-data/refresh-desktop-file-onedrive
• Embed Power BI reports in SharePoint (recommended approach):
  https://learn.microsoft.com/power-bi/collaborate-share/service-embed-report-spo

[GilbertQ]

Hi @YC1218 

All reports are always rendered via the Power BI service. So if you set up a schedule refresh in the Power BI service, your users will then see the updates to the data. If you make changes to the visuals in the Power BI report, you will then have to upload that into the Power BI service for your users to see the change.