Forum Discussion

MarcusMarinho's avatar
MarcusMarinho
New Member
5 days ago

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

Report Server

4 Replies

  • Kannan_n's avatar
    Kannan_n
    Icon for Resolver II rankResolver II
    2 days ago

    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

    • MarcusMarinho's avatar
      MarcusMarinho
      New Member
      1 day ago

      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

       

  • tayloramy's avatar
    tayloramy
    Icon for Super User rankSuper User
    5 days ago

    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

  • MarcusMarinho's avatar
    MarcusMarinho
    New Member
    5 days ago

    I made a mistake... On the Microsoft documentation says that it wouldn't be working.