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