Hi everyone,
Can VBA be used to "control" Power Query, or can there be dynamic query parameters? I'm relatively new to Power Query (in fact, still using Excel 2010 version). For example, if I have a standard SQL query that would need to be updated for different users, can I parameterize it and then either through VBA get the value from the user and then pass it to Power Query, or could I make reference to a place in the workbook before Power Query refreshes? See sample query below.
select *
from database.tableXYZ
where report_dt = '_____' and location = '_____'
Thanks,
Crystal
Can VBA be used to "control" Power Query, or can there be dynamic query parameters? I'm relatively new to Power Query (in fact, still using Excel 2010 version). For example, if I have a standard SQL query that would need to be updated for different users, can I parameterize it and then either through VBA get the value from the user and then pass it to Power Query, or could I make reference to a place in the workbook before Power Query refreshes? See sample query below.
select *
from database.tableXYZ
where report_dt = '_____' and location = '_____'
Thanks,
Crystal