Forum Discussion

bjnodello's avatar
bjnodello
Helper II
9 years ago

Error configuring Personal Gateway with SharePoint 2010 list

Hello All,

 

I am having issues scheduling a refresh for a SharePoint List.  I have no issues refreshing the data manually from within Power BI Desktop.

 

When scheduling the refresh I am prompted to provide credentials.  The credentials for my SQL Server connection work fine for this dataset, Entering credentials for the SharePoint List fails (error in image below).

 

This is not my area of expertise, but looks like it is getting caught up at some security pass through and not making it to the actual SharePoint site?  The URL in the error differs from the URL for the SharePoint site.

 

Any ideas on what I may be doing wrong?

 

Thanks!

 

Brett

 

 

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi bjnodello,

    How do you connect to the SharePoint list from Power BI Desktop? When connecting to SharePoint list from Power BI Desktop, please firstly enter the URL of your SharePoint site as shown in figure 1, choose Windows authentication to sign in as shown in figure 2, then choose SharePoint list from Navigator.


                                              figure 1

    "

                                             figure 2


    After that, when you publish the dataset to Power BI Service,  then check if you are able to schedule refresh for the SharePoint list. You can check the example which I have tested successfully in my Power BI Service.



    Thanks,
    Lydia Zhang

    • bjnodello's avatar
      bjnodello
      Helper II
      9 years ago

      Thanks Anonymous,

       

      I am aware of how to connect to a SharePoint list.  I have the list connected and working in Power BI desktop.  My issue is that I cannot get the personal gateway to work with it.  If you look at the image in my post I get an error.  I do have the enterprise gateway working with this dataset.

       

      Thanks,

       

      Brett

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi bjnodello,

        Based on my reserach, the error in your image could occur when entering wrong credential. Have you checked additional error when expending "Show details"?

        Based on my test, when we enter correct credential in Power BI Desktop, there is no need to enter it again in personal gateway. Thus, we need to verify that if you enter root url of your sharepoint site in Power BI desktop and choose windows authentication.

        Thanks,
        Lydia Zhang