Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Saxon10
Post Prodigy
Post Prodigy

Update SQL Server database data into same Excel sheet and column

Hi,

 

I would like to get the SQL Server data always in the same Excel sheet and column instead of creating new Excel sheet and columns. Is that any chance or option are available in Excel or Power Query Editor?

 

Example:

 

SQL:

 

The SQL Server table contains only one column and it’s called supplier.

 

EXCEL:

 

I have Excel called Template. In this, I have a one sheet which is called Data with two columns Item Supplier.

I would like to get the supplier column's data from SQL table into existing Excel sheet Data in Supplier column.

Can you please share is there any article already in place also advise is there any Excel supporting tools are available so I can add-in Excel.

 

have installed the latest version of MS Office.

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Hi @Saxon10 

This is exactly what Power Query is built for.  Looking at your problem you will need to do this in Power Query in Excel, not in Power BI Desktop.

Once you make a connection to your SQL database you load the table into the Power Query editor

sqlc.png

 

After making any transformations you need, click on Close & Load To

candlt.png

 

and choose to save to a table in your Excel worksheet

loadto.png

 

Further reading

Introduction to Microsoft Power Query for Excel - Excel

Getting Started with Power Query - Excel (microsoft.com)

Add a query to an Excel worksheet (Power Query) - Excel (microsoft.com)

 

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

2 REPLIES 2
PhilipTreacy
Super User
Super User

Hi @Saxon10 

This is exactly what Power Query is built for.  Looking at your problem you will need to do this in Power Query in Excel, not in Power BI Desktop.

Once you make a connection to your SQL database you load the table into the Power Query editor

sqlc.png

 

After making any transformations you need, click on Close & Load To

candlt.png

 

and choose to save to a table in your Excel worksheet

loadto.png

 

Further reading

Introduction to Microsoft Power Query for Excel - Excel

Getting Started with Power Query - Excel (microsoft.com)

Add a query to an Excel worksheet (Power Query) - Excel (microsoft.com)

 

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


thank you so much for your help and advice. This is really nice. 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.