Forum Discussion
Solved
Using an Excel named range as the SQL for a power query
Hi, My apologies if this has already been answered but I've spent hours searching and can't find the answer anywhere. I would like to use an Excel named range as the SQL script for a query in...
either that, or source your SQL query text from elsewhere (like a parameter, or text file on a sharepoint)
So to confirm that I understand you, it's not possible to use the SQL script that's in the named range, rather I'd have to actually specify the script. So when the ZZZ needs changing I'd have to do that manually, update the Power Query and re-run each time?
either that, or source your SQL query text from elsewhere (like a parameter, or text file on a sharepoint)
OK, thanks for you advice Ibendlin