Credential Connection string to Sharepoint online in on prem Report Server

[prady2581]

hello team.

I have created a PowerBI report that connects to a SharePoint Online folder that contains multiple Excel files. I uploaded this to our On-Premise Report Server (Sept2024). I want to create a daily schedule refresh. In the Data Sources section, it displays an error as shown below. Is there a specific format that we need to provide? I'm selecting the Windows authentication type. Earlier when it used to connect to SharePoint on-premises, it used to work correctly.

[d_gosbell · Accepted solution]

Unfortunately Sharepoint Online is not a supported data source for scheduled refresh. see Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn 

Your options are to either put these reports on the Power BI service or use some other process to copy the data to a location / data source that does support scheduled refresh.