Forum Discussion
How to use custom SQL select statement in excel
Hi everyone, I have an Excel workbook in which i have 3 queries that I have imported using the "Get data from Table/Table" function. I need to use a select statement to retrieve certain informatio...
You may embed SQL query only within connection to SQL database. If you query the tables from the Excel sheet use Merge Queries, Filter, etc in Power Query Editor menu (and/or M-Script code if you are familiar with it).