power bi report server refresh schedule from clooud data source

[Sofinobi]

hi all,

i'm not sure, but i need a confirmation if it is possible to schedule a refresh from a sharepoint- file in power bi report server.

thank you

[v-yohua-msft]

Hi, @Sofinobi 

Yes, you can schedule a refresh from a SharePoint file in Power BI Report Server.

Scheduled refresh for Power BI reports allows the report's data to be kept up to date. This feature is specific to Power BI reports with embedded models, which means you've imported data into the report instead of using a live connection or DirectQuery. When importing data, the data is disconnected from the original data source and needs to be updated to keep the data up-to-date. Scheduled refreshes are ways to keep your data up to date.

You can check the following link:

Power BI report scheduled refresh in Power BI Report Server - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sofinobi]

thank you @v-yohua-msft ,

are you sure about youor answer? cause for me it doesn't work

[d_gosbell]

No this is not possible, the on-prem report server does not support scheduled refresh to Sharepoint Online see Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn

[Sofinobi]

thank you @d_gosbell  but as you see above from @v-yohua-msft he says yes. but for me it doesn't work

[d_gosbell · Accepted solution]

---

@Sofinobi wrote:

 but for me it doesn't work

---

This is because @v-yohua-msft is wrong.

If you check the documentation link I provide none of the cloud sources that require OAuth2 authentication (like Sharepoint Online does) are supported for scheduled refresh.

You can do scheduled refresh from the on-prem Report Server to on-prem Sharepoint, but not to Sharepoint Online.

[Sofinobi]

thank you my friend

[v-yohua-msft]

Hi, @Sofinobi 

I'm sorry for giving you the wrong information. And it's also glad to see that you've solved the problem.

Best Regards

Yongkang Hua