Get Data Load button grayed out when trying to load SharePoint List

[pjkfifield14]

I can access the SharePoint lists after choosing get data but when I select a list the "load" and "edit" buttons are both grayed out so I can't go any further.  The cancel button is the only one that works.  

[nadiavr]

 I have this same issue. How did this get resolved?

[pjkfifield14 · Accepted solution]

The solution that worked was to use the 'Web' connector under "Get Data". If you paste the web URL to the file, a pop up should then ask you how to connect to it, which in my case I used the "Organizational account" and clicked on the "sign in" button to authenticate. That connection info is then saved under File / options and settings / data source settings if you need to adjust it. 

[v-easonf-msft]

Hi ,  @pjkfifield14 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.
More people will learn new things here. If you haven't, please feel free to ask.

Best Regards,
Community Support Team _ Eason

[v-easonf-msft]

Hi , @pjkfifield14 

Please refer to this document to  connnect to sharepointlist.

For the issue, I cannot reproduce it here.I have tested  it and everything well here .

Please confirm whether the  table  you desired have been selected successfully .

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support to get further help.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@pjkfifield14 , do you have comma in any of the list name ?