Forum Discussion

zbarrera's avatar
zbarrera
Regular Visitor
9 years ago
Solved

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...
Need Help
  • zbarrera's avatar
    zbarrera
    9 years ago

    Hi Lydia.

     

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

     

    Regards.

     

    zbarrera

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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 Zhang