Forum Discussion
Sharepoint List
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
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.)
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.
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
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)"
