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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.