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


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



    Friday, March 28, 2014 10:34 AM


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

    Sunday, November 02, 2014 8:37 PM

All replies