Forum Discussion

Fernandostn's avatar
Fernandostn
Frequent Visitor
11 months ago

I cannot connect sharepoint Data source in power bi report server on premises

I created a report that connects to Sharepoint, I can refresh it in the Power BI desktop normally, but when I try to configure the data source an error appears.

 

I've tried several ways and it still hasn't worked.

 

How can I fix this problem?

Thank you.

 

 

"Need Help"

17 Replies

      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support
        11 months ago

        Hi  Fernandostn ,

        Thanks for reaching out to the Microsoft fabric community forum. 

         

        Since you can refresh in Power BI Desktop but not in Report Server, it looks like an authentication issue between Report Server and SharePoint. A few things you can try:


        In Report Server, Windows Authentication often fails for SharePoint Online. Try changing it to OAuth2 or Basic Authentication instead.

        Make sure the account running the Power BI Report Server service has access to the SharePoint site.

        Double-check the SharePoint URL (it should be the site or document library root, not just a file link).

         

        If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

        Best Regards, 
        Community Support Team  

  • Nasif_Azam's avatar
    Nasif_Azam
    Icon for Super User rankSuper User
    11 months ago

    Hey Fernandostn ,

    The issue occurs because Power BI Report Server (PBIRS) does not support OAuth authentication for SharePoint Online, which is why it works in Power BI Desktop but fails on PBIRS. PBIRS cannot use the same OAuth credentials as Desktop. The SharePoint connector isn’t fully supported on PBIRS; you need to use an OData feed instead.

     

    1) Use OData Feed in Power BI Desktop (Report Server version):

    • Go to Get Data → OData Feed.
    • Use the SharePoint list OData URL:
     https://<your-site>.sharepoint.com/_vti_bin/ListData.svc

    Or for modern lists:

     https://<your-site>.sharepoint.com/_api/web/lists/getbytitle('YourListName')/items

     

    2) Publish to PBIRS and Configure Data Source:

    • In PBIRS → Manage → Data Sources, set:
      • Authentication Type: Basic
      • Enter a valid SharePoint username and password (often a service account).

     

    3) Ensure PBIRS Server Can Access SharePoint: If using SharePoint Online, the PBIRS server needs outbound internet access.

     

    4) Match Versions: Make sure you are using the same version of Power BI Desktop (Report Server edition) as your PBIRS instance.

     

     

    Best Regards,
    Nasif Azam

    • v-menakakota's avatar
      v-menakakota
      Icon for Community Support rankCommunity Support
      11 months ago

      Hi  Fernandostn ,

      Thanks for reaching out to the Microsoft fabric community forum. 

       

      I would also take a moment to thank Nasif_Azam , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 

       

      I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

      Best Regards, 
      Community Support Team  

    • Fernandostn's avatar
      Fernandostn
      Frequent Visitor
      11 months ago

      Hi Nasif_Azam, 

       

      I did the test as you said

       

       

      but the error continues.

       

       

      I also checked the item below:

       

      3) Ensure PBIRS Server Can Access SharePoint: If using SharePoint Online, the PBIRS server needs outbound internet access.  - It's ok

      4) Match Versions: Make sure you are using the same version of Power BI Desktop (Report Server edition) as your PBIRS instance. + It's ok

       

      Thanks.