Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
TGu990131
Regular Visitor

fail to connect sharepoint Data source in power bi report server

Hi everyone:

 

I select sharepoint folder as datasource when i make report in power bi desktop. I can refresh it in the power bi desktop.After i upload the report on the report server. I try to connect the datasource and schedule refresh.Authentication Type has two options,anonymous and window authentication. So i think it is sharepoint on premises.Because if it is sharepoint online.it shouldn't have these options.However, unexpected error encountered when i choose the two options. I use my corporate domain and username when the authentication is windows authentication. The same error .Log on failed. Ensure the user name and password are correct.

TGu990131_1-1674096687269.png

 

 

TGu990131_0-1674096375330.png

TGu990131_2-1674096881264.png

 

I wish you can help me to solve this issue. You can save my life!

6 REPLIES 6
jinyuann
Frequent Visitor

Hi @TGu990131 , Are you able to resolve this issue as i am also facing the same problem as you and i not sure how to resolve this when it explicitly states that sharepoint on prem supports Scheduled refresh

Are you using NTLM ? 

d_gosbell
Super User
Super User

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. Report Server is designed for scenarios where you cannot use any cloud resources for storing data. If you have a hyrbid scenario where some data is on-prem and some is in the cloud then you can either publish your report to the Power BI cloud service and use a gateway to connect to the on-prem data or you will need to pull your Sharepoint data down to an on-prem source which Report Server can do a scheduled refresh against (like a SQL database)

freginier
Solution Specialist
Solution Specialist

Can you connect to SharePoint Folder directly from your Power BI Report Server using Power BI Desktop ?

 

______________________________________________________

If you found this post helpful, please give Kudos C

Yes,I can  connect to SharePoint Folder in Power Bi Desktop.

That means it PBRS authentication issue.

 

You need to configure Windows Authentication on PBRS with the same method as your SharePoint Kerberos, NTLM or Negociate (both) 

https://learn.microsoft.com/en-us/sql/reporting-services/security/configure-windows-authentication-o...

 

 

______________________________________________________

If you found this post helpful, please give Kudos C

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.