Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi Lydia.
Thank you very much for your answer. I solved this issue changing domain name by IP and port.
Regards.
zbarrera
Hi Lydia.
Thank you very much for your answer. I solved this issue changing domain name by IP and port.
Regards.
zbarrera
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.