Forum Discussion
Executing list of sql queries stored in database table
Hi Anonymous,
I think you can try to parameterized connection string to achieve two steps getting data operation.
At the first, you can getting data from the SQL table that stored the t-SQL query lists. The second, you can use query parameters to control and pick up specific row values to use them as conditons in a new query step with data connector to getting data.
Table.SelectRows - PowerQuery M | Microsoft Learn
Regards,
Xiaoxin Sheng
Hi Anonymous,
I think you can try to parameterized connection string to achieve two steps getting data operation.
At the first, you can getting data from the SQL table that stored the t-SQL query lists. The second, you can use query parameters to control and pick up specific row values to use them as conditons in a new query step with data connector to getting data.
Table.SelectRows - PowerQuery M | Microsoft Learn
Regards,
Xiaoxin Sheng