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

Hi Guo_au

 

Thanks for the reply

i am getting the error while following that work around.

 

WEB1https://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=

in the above list in the view iqy quary up to what portion i need to take for the web connection.

 

can you please give me some sample view url for the web connection in power bi

 

Thanks!!

Nagaraju

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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