Forum Discussion
Troubles accessing to Sharepoint list using credentials
I am trying to get data from Sharepoint list. This site require credential to access. When I use Web option, Power BI identify “tables” of “Authentication page”, it doesn’t take the url that contains the List. Please your help!
Thank you
Hi Lydia.
Thank you very much for your answer. I solved this issue changing domain name by IP and port.
Regards.
zbarrera
3 Replies
Hi zbarrera,
Do you connect to SharePoint Online list or on-premises SharePoint list from Power BI? Which authentication type do you use?
If you connect to SharePoint Online list, please use the “Get Data->SharePoint Online list” entry in Power BI Desktop and input site URL , then use Organizational Account to connect to it. For detailed steps, please review this blog: http://www.netwoven.com/2016/07/analyzing-sharepoint-list-data-using-power-bi-2/.
However, if you connect to on-premises SharePoint list, the “Get Data->SharePoint list” entry in Power BI Desktop, enter site URL and use your Windows credential to connect to it , for more details, please review this similar thread: https://community.powerbi.com/t5/Integrations-with-Files-and/Power-BI-connection-with-Sharepoint/td-p/86149 .
Thanks,
Lydia ZhangHi Lydia.
Thank you very much for your answer. I solved this issue changing domain name by IP and port.
Regards.
zbarrera
- I used public url.
