Execute Query from Table

[mehulvt]

Hi,

I have a table which has several queries stored in a column in table.

For Example,

QueryTable1

Id SQL

1   select col1, col2 from customers

2   select col1, col2 from products

I want that when the user clicks on 1, Power BI should execute the query in SQL colum for 1 and return the data.

I then plan to create a drill through report for the records which are returned from the query executed from the table.

Is this possible in Power BI right now?

[v-chuncz-msft · Accepted solution]

@mehulvt,

You may create a custom function and then invoke it for each row in Query Editor.