Forum Discussion
Helper ICredential Connection string to Sharepoint online in on prem Report Server
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.
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.
1 Reply
- d_gosbell
Super User
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.