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 gbritton,

 

Have you resolved your pblm? i have also same requirement

 

Thanks!!

Nagaraju

 

    • 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.