I am trying to consume an OData feed from an SSRS report using Power Query ( latest release on Excel 2010 x32). The Report server is in my company intranet.
In the SSRS report, I can generate an Atom service file. When I use this file in PowerPivot, I can successfully import the report data and refresh it on demand. But I would like to do the same thing in Power Query using the "From OData feed" feature.
1. I have tried supplying the URI to the service file
I get this error :
DataFormat.Error: The supplied URL must be a valid 'http:' or 'https:' URL.
2. I tried supplying the URL that the service file contains, but without success.
I get this error:
DataFormat.Error: OData: The given URL neither points to an OData service or a feed
Am I missing something, or is what I am trying to do not supported ?
The OData support in Power Query does not currently work with the Atom feed generated by SSRS. This is something we're hoping to change in the near future.
My Current workaround for pulling data from SSRS until the dev team have worked out the odata issue is to pull the report in as a csv file:
I also tried pulling an excel file from SSRS with no success.
if anyone has had luck pulling in an excel file from SSRS i would like to know how.
Is there a rough release date for the odata functionality?