Executing Oracle Stored Procedure RRS feed

  • Question

  • Can you execute and Oracle procedure with and input variable and ref cursor in Power Query?  If so, how.  If not, can you create a reporting services report and publish to Sharepoint 2013 and then use the data feed option? 
    Wednesday, April 23, 2014 5:52 PM


  • No, Power Query does not currently support Oracle ref cursors.

    It's possible to consume a Reporting Services data feed from Power Query using the "From Web" option, but the experience isn't ideal. The SSRS data feed is an ATOM feed, so you'd need to extract the values you're looking for out of the resulting XML document. (Power Query's "From OData" option doesn't work here, since it requires a $metadata document to infer the schema)

    ATOM support in Power Query is on our backlog - we're hoping to get to it within the next few months.

    Wednesday, April 30, 2014 3:48 PM