Import data from Oracle database by executing a package RRS feed

  • Question

  • Hi,

    I installed PowerPivot add in for excel and created a connection to Oracle database and able to import data from Oracle database's tables.

    But, my requirement is to execute a oracle package and get data into PowerPivot?

    Is that possible? If yes, How to do that?


    Please advice


    Thursday, October 20, 2011 5:13 AM


  • From the datasource connection wizard, it seems we can only import tables or views from the database, or the data returned from a query.

    However here I still would recommend you to submit a feedback to Microsoft Connect at this link at this link https://connect.microsoft.com/SQLServer/Feedback This connect site is a connection point between you and Microsoft. Your feedback enables Microsoft to make software and services the best that they can be, Microsoft might consider to add this feature in the following release after official confirmation.

    Challen Fu

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by Challen Fu Friday, October 28, 2011 7:47 AM
    Friday, October 21, 2011 7:08 AM