Troubles accessing to Sharepoint list using credentials

[zbarrera]

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

[zbarrera · Accepted solution]

Hi Lydia.

Thank you very much for your answer. I solved this issue changing domain name by IP and port.

Regards.

zbarrera

[zbarrera]

I used public url.

[Anonymous]

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-... .

Thanks,
Lydia Zhang