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 ?