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. 

  • 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