Merging Static Excel data with Dynamic data from SQL Server RRS feed

  • Question

  • Hi Team,

    I have some data in Excel - sheet1 which would be static.

    Now I need to import data from SQL Server (using a query) and Union above static data with this SQL data and later I will have to create PowerPivot table in Sheet2.

    Which is suitable option for me to import data from SQL to excel as I see "From SQL Server" option under "Data" and "Power Query" tab as well.
    How to merge above SQL data with existing static data?

    MCP, MCTS, MCSA (SQL Server 2012)

    Wednesday, August 19, 2015 12:59 PM


All replies