Forum Discussion
How to read SQL requests in an Excel file?
Well, technically that is possible, but keep in mind that if your SQL changes in any way, and you've used a transformation that references the structure of that query (e.g. a column name), then it'll break.
I guess I'm curious as to what you're actually trying to do, because allowing arbitrary SQL from an Excel file to form your data seems kinda brittle. I'd recommend having that SQL logic actually in Power BI itself. I'd have to know more details as to the nature of your queries and how they might change in that Excel file.
I would like to use a list of sql to verify if some problem on the database are resolved, if there's no regression, some basic control of tables, etc. My list of SQL will change of course, and I would like to refresh a report and see if everything's ok.