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

You should get several ideas from this link.

http://www.excel-sql-server.com/excel-sql-server-import-export-using-vba.htm#Introduction

There are several other ways to do this as well.  Post back if you have additional questions.

Hi Vaibhav,

According to your description, this issue is more related to PowerPivot for Excel, the PowerPivot forum is a better place for this issue, and we will move it there for you.

Regards

Starain

For a "real" UNION where you want to add rows from one table under the other, you should Power Query's append-function: https://support.office.com/en-nz/article/Append-queries-Power-Query-e42ca582-4f62-4a43-b37f-99e2b2a4813a?ui=en-US&rs=en-NZ&