Forum Discussion

MarcusMarinho's avatar
MarcusMarinho
New Member
3 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

3 Replies

  • MarcusMarinho's avatar
    MarcusMarinho
    New Member
    3 days ago

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

  • tayloramy's avatar
    tayloramy
    Icon for Super User rankSuper User
    3 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

  • Kannan_n's avatar
    Kannan_n
    Icon for Advocate III rankAdvocate III
    6 hours 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