none
Issue consuming Odata feed with Power Query (not in Power BI)

    Question

  • 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

    = OData.Feed("file:///C:/Users/Bdarbonneau/Documents/temp/Manuf_cycle_time_mapping_table.atomsvc")

    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. 

    = OData.Feed("http://myssrsserver:8080/ReportServer?%2FMANUFACTURING%2FArchive%2FManuf_cycle_time_mapping_table&rs%3ACommand=Render&rs%3AFormat=ATOM&rc%3AItemPath=Tablix1")

    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 ? 

    Regards,

    Bertrand

    Friday, March 28, 2014 10:34 AM

Answers

  • 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.
    Friday, March 28, 2014 1:36 PM

All replies

  • 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.
    Friday, March 28, 2014 1:36 PM
  • Has the near future cometh yet?

    We have a use case to use an SSRS invoice-lookup report, with Power Query.  It would be nice to use these ATOMSVC file that SSRS provides.

    Sunday, June 01, 2014 1:45 PM
  • July 1. The change is yet to come.
    Tuesday, July 01, 2014 11:37 AM