cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NewBee117
Regular Visitor

Data refresh problem - login error with on-prem SharePoint site

I have a simple BI report pulling data from a SharePoint 2016 site that is visible on the internet. It runs fine in the Desktop version, however, after published to BI website, I am getting refresh error. Not sure why I only have anonymous login option? 

 

NewBee117_0-1632418855725.png

 

In the Desktop app, I specified it to use Windows login. I tried both options, fails.

NewBee117_1-1632419027666.png

 

 

 

 

1 ACCEPTED SOLUTION

Hi @NewBee117 

 

Yeah it does say that but if it is an on-prem sharepoint it would need the gateway to allow you to authenticate with the windows credentials.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
GilbertQ
Super User
Super User

Hi @NewBee117 

 

I would use the On-Premise Gateway to connect to your On-Prem SharePoint. 

 

You can only connect without the gateway to cloud data sources.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@GilbertQ The gateway section said I don't need a gateway.

 

NewBee117_0-1632435513941.png

 

 

Hi @NewBee117 

 

Yeah it does say that but if it is an on-prem sharepoint it would need the gateway to allow you to authenticate with the windows credentials.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!