Home Forums Data Warehousing PowerPivot using powerpivot to join a SQL Database query to a table defined in a PowerPivot Excel workspace? RE: using powerpivot to join a SQL Database query to a table defined in a PowerPivot Excel workspace?

  • May 7, 2012 at 1:11 am

    #1483975

    Hi,

    have you considered a Integration Solution(SSIS) wherein the excel file would act as a source and you can later introduce a MERGE transformation to join data as required.

    Raunak J