Sharepoint List

[gopowerbi]

Hello,

I wanted to import a sharepoint list but I cannot paste my Sharepoint URL which is like:

http://intranet.net.abc.com/sites/ttt/123/123/abc/abc.aspx

Could somebody help me by giving me any advice how to solve the problem? Thank you in advance

[Eric_Zhang]

---

@gopowerbi wrote:

Hello,

I wanted to import a sharepoint list but I cannot paste my Sharepoint URL which is like:

http://intranet.net.abc.com/sites/ttt/123/123/abc/abc.aspx

Could somebody help me by giving me any advice how to solve the problem? Thank you in advance

---

@gopowerbi

As the error tips say, "Enter the site root URL only", so you can try
http://intranet.net.abc.com/sites/ttt

By the way, for on-premises SharePoint, use the "SharePoint List" when getting data(There's another "SharePoint Online List" for SharePoint online.)

[gopowerbi]

Thank your for you answer.

When I paste the root URL only, the next window showed in Power BI doesn't show me the table I want. It might be because of filters and/or whatsoever proccesed in .aspx URL.

[gpiero]

In your URL abc.aspx is a page

http://intranet.net.abc.com/sites/ttt/123/123/abc/​abc.aspx

If your list is under .../123/123/....

you should paste

http://intranet.net.abc.com/sites/ttt/123/123

[gopowerbi]

Thank you. My list is under http://intranet.net.abc.com/sites/ttt/123/123/abc/​​abc

but when I try it gives me the error:

Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Not Found)"