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

[Fernandostn]

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.

[Nasif_Azam]

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

[Fernandostn]

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]

Hi @Fernandostn ,

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

Thank you.

[Fernandostn]

hi, @v-menakakota ,

The problem is not here, the problem occurs when I publish the report on Power BI Report Server on premises.

When I configure these credentials, the following message appears: "Failed to log in. Make sure the user is correct."

thanks

[v-menakakota]

Hi @Fernandostn ,

Kindly review the connection string as well as the Windows authentication username and password, since the error message suggests that one or more of these values may be incorrect.

Thank you.

[v-bmanikante]

Hello @Fernandostn 

I am also part of CST Team and we’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

Regards,

B Manikanteswara Reddy

[Fernandostn]

Hello @v-bmanikante 

My problem still persists.

And to be honest, I think SharePoint Online is not supported for scheduled refresh in the Power BI Report Service on-promise.

There are many similar problems here in the community, and none of them have worked. So many users have tried in various ways and still haven't succeeded. It's really strange.

Our friend @d_gosbell  said it's not possible.

"As documented here, Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn, SharePoint Online is not supported for scheduled refresh."

https://community.fabric.microsoft.com/t5/Report-Server/fail-to-connect-sharepoint-Data-source-in-po...

Could someone from Microsoft confirm?

Thank you.

[v-menakakota]

Hi @Fernandostn ,

SharePoint Online is not supported for scheduled refresh in Power BI Report Server.

Since this appears to be a limitation and you’ve already tested multiple approaches, I’d recommend opening a Microsoft Support ticket so the product team can confirm and review your specific environment in detail.

Please refer below link on how to raise a contact support or support ticket. 
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn 

Best Regards, 
Community Support Team  

[Fernandostn]

Hi @v-menakakota ,

Thank you very much for your feedback.

I'll open a Microsoft Support ticket.

Thanks.

[v-menakakota]

Hi @Fernandostn ,

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]

Hi, @v-menakakota 

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

Thanks

[v-menakakota]

Hi  @Fernandostn   ,

Thank you for the update, If the response has addressed your query, please Accept it as a solution so that other community members can find it easily. 

Best Regards, 
Community Support Team.

[v-menakakota]

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  

[MasonMA]

Hi, 

Found a similar topic below on Stack overflow. You can give it a try. 

Unable to connect to data source in power bi server report to sharepoint site - Stack Overflow 

[Fernandostn]

I've tried, it didn't work.

[v-menakakota]

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  

[Fernandostn]

Hi @v-menakakota ,

OAuth2 or Basic option does not appear for me in Power BI on premises

I granted permission to the Power BI service account in SharePoint, but it still didn't work.

Thanks