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 ...
"Need Help"
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.

     

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

      Hi Fernandostn ,

      Can you please check whether the username and password are correct.

      Thank you.

      • Fernandostn's avatar
        Fernandostn
        Frequent Visitor
        11 months ago

        Hi, v-menakakota 

         

        Yes, that's correct, I was able to authenticate.

         

        Thanks