Gateway, SharePoint list and Credentials

[bcobrien1977]

Hi,

I unable to refresh a report in Power BI Service that I added a new source (SharePoint list).

I have taken the report over and let others try and it still doens't work.

Here is how the connections look.  

Can anyone provide any assistance?  Thanks

[kevingauv]

It seems that a similar issue have been reported internally at Microsoft .

see the following thread:
https://community.powerbi.com/t5/Service/Sharepoint-source-suddenly-un-map-from-gateway-and-cannot-b... 

[skygold16]

I recently encountered the similar issue and the credentials will work only when you are the owner of the dataset. May be worth trying. 

[kevingauv]

For, us, we are the owner and it is not working.

[bcobrien1977]

Hi,

I guess it boils down to two things.

1) can you have multiple sources (SQL and Sharepoint) in the same report and use the gateway to refresh?

2) What creddentials should you use for SharePoint?

Thanks

[kevingauv]

Hi, we got the same problem here.

We have a dataset that use the enterprise gateway to retreive data from on-prem server that run succusfully on the service in the past.

Now, we had a Sharepoint list has a new source and we are not able to select the gateway anymore.