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. 

      • 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