topic Re: I cannot connect sharepoint Data source in power bi report server on premises in Report Server

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

Fernandostn — Fri, 19 Sep 2025 13:26:25 GMT

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.

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

MasonMA — Thu, 18 Sep 2025 18:47:57 GMT

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

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

Fernandostn — Thu, 18 Sep 2025 20:07:39 GMT

I've tried, it didn't work.

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

v-menakakota — Fri, 19 Sep 2025 09:46:09 GMT

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

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

Fernandostn — Fri, 19 Sep 2025 14:44:46 GMT

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

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

Nasif_Azam — Sat, 20 Sep 2025 19:27:15 GMT

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

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

v-menakakota — Mon, 22 Sep 2025 11:13:45 GMT

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

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

Fernandostn — Mon, 22 Sep 2025 19:44:56 GMT

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.

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

v-menakakota — Tue, 23 Sep 2025 04:45:04 GMT

Hi Fernandostn ,

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

Thank you.

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

Fernandostn — Tue, 23 Sep 2025 18:35:03 GMT

Hi, v-menakakota

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

Thanks

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

v-menakakota — Wed, 24 Sep 2025 06:52:18 GMT

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.

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

Fernandostn — Wed, 24 Sep 2025 12:43:24 GMT

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

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

v-menakakota — Thu, 25 Sep 2025 06:43:21 GMT

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.

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

Anonymous — Tue, 30 Sep 2025 06:45:23 GMT

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

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

v-menakakota — Fri, 03 Oct 2025 05:18:57 GMT

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

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

Fernandostn — Mon, 06 Oct 2025 13:30:19 GMT

Hello Anonymous

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-power-bi-report-server/m-p/3053950

Could someone from Microsoft confirm?

Thank you.

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

v-menakakota — Tue, 07 Oct 2025 05:08:33 GMT

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

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

Fernandostn — Tue, 07 Oct 2025 14:55:51 GMT

Hi v-menakakota ,

Thank you very much for your feedback.

I'll open a Microsoft Support ticket.

Thanks.