Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Gateway, SharePoint list and Credentials

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

 

 

Need Help

5 Replies

  • kevingauv's avatar
    kevingauv
    Advocate III
    3 years ago

    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. 

  • skygold16's avatar
    skygold16
    Helper II
    3 years ago

    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's avatar
      kevingauv
      Advocate III
      3 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        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