Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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.
I have installed the latest version of MS Office.
Solved! Go to Solution.
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
After making any transformations you need, click on Close & Load To
and choose to save to a table in your Excel worksheet
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
Proud to be a 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
After making any transformations you need, click on Close & Load To
and choose to save to a table in your Excel worksheet
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
Proud to be a Super User!
thank you so much for your help and advice. This is really nice.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |