Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
You may create a custom function and then invoke it for each row in Query Editor.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |