Forum Discussion

gbritton's avatar
gbritton
Advocate II
10 years ago

sharepoint view

I want to import data from a SharePoint List into Power BI Desktop.  However, the list has several views available.  How do I specify which View I want?
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Try again without "WEB1" in the URL. My current work environment does not have SharePoint. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Guo,

 

Thanks for the quick reply

i am using the below entaire url still getting the error

https://xxxyyyzzz.com/app/admin-review/_vti_bin/owssvr.dll?XMLDATA=1&
List={B53D6D9C-AC94-4DE7-8A5D-EF35ED42AAA7}&
View={ED21F1FF-8057-4058-9E56-F6DF6145C990}&
RowLimit=0&
RootFolder=
Selection={B53D6D9C-AC94-4DE7-8A5D-EF35ED42AAA7}-{ED21F1FF-8057-4058-9E56-F6DF6145C990}
EditWebPage=Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
SharePointApplication=https://xxxyyyzzz.com/app/admin-review/_vti_bin
SharePointListView={ED21F1FF-8057-4058-9E56-F6DF6145C990}
SharePointListName={B53D6D9C-AC94-4DE7-8A5D-EF35ED42AAA7}
RootFolder=

 and i tried to reduced that url upto list id and view id below is the link but still getting the error

https://xxxyyyzzz.com/app/admin-review/_vti_bin/owssvr.dll?XMLDATA=1& List={B53D6D9C-AC94-4DE7-8A5D-EF35ED42AAA7}& View={ED21F1FF-8057-4058-9E56-F6DF6145C990}

I know currently your not useing share point connection,but if you rember any thing please reply me ,it would be helpful for us

 

Thanks!!

Nagaraju.G