Importing from PowerPivot

  • Would someone be able to point me in the correct direction on how to import data from a Power Pivot workbook to SQL SERVER?

    Importing to Power Pivot is simple, but never had to import from Power Pivot.

    Thank you for any help!

  • butcherking13 (2/13/2015)


    Would someone be able to point me in the correct direction on how to import data from a Power Pivot workbook to SQL SERVER?

    Importing to Power Pivot is simple, but never had to import from Power Pivot.

    Thank you for any help!

    As far as I know, it isn't possible.

  • Not sure if it's possible, but one way might be to use an ADO connection from inside Excel to push the results to SQL Server...

  • I did find out you can push it to SSAS, but the goal was to bring it in to a table in SSMS. Still trying and I will look into your suggestion. Thanks!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply