Forum Discussion
Get Data Load button grayed out when trying to load SharePoint List
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.
- 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.
5 Replies
Anonymous , do you have comma in any of the list name ?
Hi , Anonymous
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 _ EasonHi , Anonymous
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 _ EasonI have this same issue. How did this get resolved?
- 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.
