Forum Discussion
Yael
Helper IV
Helper IVwhat if analysis when connecting live
Hello, Can I use what if analysis when connecting live - Tabular or Direct Query? Thank you!
In that case, you need to build your auxiliar tables to do the whatif scenario you need in the source database.
Later, in Power BI Desktop you can develop the measures for the analysis.
The only difference between import or direct query in a whatif scenario is where auxiliar tables must be created.
Best,
Jorge.
GeorgeBuster
Advocate III
Advocate IIIIn that case, you need to build your auxiliar tables to do the whatif scenario you need in the source database.
Later, in Power BI Desktop you can develop the measures for the analysis.
The only difference between import or direct query in a whatif scenario is where auxiliar tables must be created.
Best,
Jorge.
YaelHelper IV
Helper IVThanks GeorgeBuster!