Forum Discussion
RS 2026 does not connect with sharepoint
Hi all, good afternoon.
I am facing a problema. I have a base that's a spreadsheet that's in the sharepoint. I have a link. When I use a PB Desktop RS, the comunication works, but to update I need to click on the update button. Ok. Not a problema.
But, when I upload the PBIX to the corporate RS, it doesn't communicate with the sharepoint. Ok. On the Microsoft documentation says that it would be working.
But, does anyone have a idea ou a experience and got a solution? I tried to put the file on my computer, but liiks like the RS doesn't get a communication. It's seens to be a communication problem between RS and computer.
Thanks
9 Replies
Thanks for everything, v-abhinavmu
I made a mistake... On the Microsoft documentation says that it wouldn't be working.
- tayloramy
Super User
Hi MarcusMarinho,
This is expected behavior.
Report Server does not connect to cloud data sources, like SharePoint Online.To use Cloud data source, Microsoft recommends the Power BI Service/ Microsoft Fabric
- Kannan_n
Resolver II
Hello MarcusMarinho
Power BI Report Server (PBIRS) is strictly an on-premises product and does not natively support direct scheduled refreshes from cloud-only endpoints like SharePoint Online via modern cloud authentication (Entra ID OAuth).
Desktop refreshes succeed on your machine because Power BI Desktop RS leverages your active user session and cached browser credentials to authenticate to SharePoint Online.
Once published to PBIRS, background scheduled data refreshes run under server service accounts or saved static credentials, which cannot interactively authenticate to SharePoint Online's cloud endpoint.
The standard workarounds are:
- Sync the SharePoint Excel file down to an on-premises network file share (UNC path like \\server\share\file.xlsx) via OneDrive Sync or a scheduled script, and point the report to that local UNC path with Windows authentication.
- Move and host the report in the Power BI Service / Microsoft Fabric, which is built for native cloud connectivity and scheduled refreshes against SharePoint Online.
Thanks
Kannan N
Hi all.
Thanks a lot for everything. I can't use others service because de company defined the PBRS. We only have this.
I already shared the folder that's the one driver, so the file would be alreay updating, but I am receiving the network patch was not found. I think it's permisson or it really doesn't work. Maybe because would be instead of PBRS and then PBS.
I think I can't do anything more until Microsoft resolve it by other way.
Thanks again
v-abhinavmuCommunity Support
Hi MarcusMarinho,
Thanks for reaching out to the Microsoft Fabric Community forum.If the file is hosted in SharePoint Online, the behavior you're seeing is consistent with the documented Power BI Report Server limitations.
Microsoft lists SharePoint Online File, SharePoint Online Folder, and SharePoint Online List as supported for cached data, but not for scheduled refresh.
The documentation also states that Power BI Report Server doesn't support OAuth-based authentication for model refresh. SharePoint Online File, Folder, and List also have no supported authentication method listed for model refresh.
For file-based sources, Microsoft documents that a local path such as C:\Users\user\Documents can't be used for a refresh plan. The path must instead be one that the Report Server can connect to, such as a network share (\\myshare\Documents).
Therefore, if you continue using Power BI Report Server, the file would need to be available through a location and authentication method supported by Report Server. A SharePoint Online file itself isn't supported for scheduled model refresh.
For more details, please refer to the below Official Microsoft documentation:
Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn
Power BI report scheduled refresh in Power BI Report Server - Power BI | Microsoft LearnI hope this helps. Please feel free to reach out if you have any further questions.
Thank you.
- v-abhinavmu
Hi MarcusMarinho,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.I v-abhinavmu , good morning.
Yes, I laready have checked the documentation. My intention was just to check if someone else had another idea and solved it by another way.
I will continue waiting. For now, I can't do anything more !
Thanks a lot for all
- v-abhinavmu
Hi MarcusMarinho,
Thank you for the update. I understand that you have already reviewed the documentation and were looking for an alternative approach.
Based on the documented Power BI Report Server behavior, there isn’t an additional supported configuration for directly refreshing a SharePoint Online file from Power BI Report Server.
If you continue using Report Server, a supported network file-share location would be the applicable approach, provided the Report Server can access the location with the required permissions.
Thank you for sharing your experience with the community.
