Forum Discussion
Solved
SQL Query from Results of Another SQL Query
The way our Agile software is configured is as follows: Themes >> Epics >> Capabilities >> Features >> Stories where each has it's own table. The issue is that we only care about a handful of Themes ...
It does, but you will wake up the firewall monster as this will result in cross query data bleed. Don't expect to get this to work in the Power BI service.
Are you looking for CTEs?
I'm trying to avoid having to update 8 SQL queries every time I want to update the WHERE clause for the Themes. I'm assuming Power BI has some functionality where they would run the SQL queries sequentially and using one to feed into the next.
It does, but you will wake up the firewall monster as this will result in cross query data bleed. Don't expect to get this to work in the Power BI service.
Unfortunate. Thanks for the feedback!