Results 1 to 4 of 4

Thread: Pulling Data from Sharepoint via Power Query - Data Format Error

  1. #1

    Pulling Data from Sharepoint via Power Query - Data Format Error



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi there,

    My organisation uses sharepoint; I'm trying to achieve the following 1) monthly downloads of data to a folder on the sharepoint site in a specific folder; and 2) pullling data from those files to a dashboard in another folder on the same site.

    In trying to test this I've set up a simple file on my desktop and tried to run a query to a sample query to the folder where the data will be downloaded to, via the "From Other Sources > From Sharepoint List" in the "Get External Data Menu" in PQ.

    When I do this with the following sample address - h t t p s colon //workspace.company.com/UK/project.aspx, the query seems to load to the editor, but I get the following error:

    DataFormat.Error: OData: The given URL neither points to an OData service or a feed: 'h t t p s colon //workspace.company.com/UK/project.aspx/_vti_bin/ListData.svc'.
    Details:
    H t t p s colon //workspace.company.com/UK/project.aspx/ vti bin/ListData.svc'


    Does anyone have any idea why this might be the case? I've spent the best part of the day trying to figure this out but without success!

    Failing that - does anyone know if its possible to pull data from a file on a sharepoint site via the 'From Web' functionality?

    Many thanks in advance,

    KJT

  2. #2
    Seeker Martinl's Avatar
    Join Date
    Dec 2016
    Posts
    13
    Articles
    0
    Excel Version
    2016 MSO (16.0.9126.2259)
    Hi kjt

    I have a similar issue that I am trying to resolve.
    Yours is different though as I notice you are putting the full path of the file in.
    try with just the main bit 'h t t p s colon //workspace.company.com/
    maybe add in the UK/

    this link may also help

    https://exceleratorbi.com.au/consoli...#comment-50368

    Good luck

  3. #3
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,666
    Articles
    0
    Excel Version
    2010 on Xubuntu
    @martini
    Be aware that this thread is 3 years old. It would be astonishing if it were not solved yet.
    Thank you Ken for this secure forum.

  4. #4
    Seeker Martinl's Avatar
    Join Date
    Dec 2016
    Posts
    13
    Articles
    0
    Excel Version
    2016 MSO (16.0.9126.2259)
    Quote Originally Posted by Pecoflyer View Post
    @martini
    Be aware that this thread is 3 years old. It would be astonishing if it were not solved yet.
    Typical...and there's me just trying to be helpful whilst I wait for some help of my own
    I should have looked at the date, but it was at the top of the list...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •