Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 11 | |
| 7 | |
| 5 | |
| 5 | |
| 3 |