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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors