Forum Discussion
What if parameter with direct query
Hi all,
Is it possible to use what if parameter with direct query method ?
Or do you have any workaround for this ?
The newest article i could find. It says no.
https://community.powerbi.com/t5/Desktop/what-if-parameter-direct-query/m-p/230242#M102696
Anonymous , I tried it once and I remember I was able to add but you have to check. It should convert it into a mix mode and should work.
Add the what if parameter and use its measure in other measure formula
3 Replies
- amitchandak
Super User
Anonymous , I tried it once and I remember I was able to add but you have to check. It should convert it into a mix mode and should work.
Add the what if parameter and use its measure in other measure formula
amitchandak
Do you mean composite models ?
I couldn't able to use composite models.My datasource is SAP BW
The following Live Connect multi-dimensional sources can't be used with composite models: SAP HANA SAP Business Warehouse https://docs.microsoft.com/tr-tr/power-bi/transform-model/desktop-composite-models- amitchandak
Anonymous , Then I doubt you can not have that. I Tried with Direct query mode and it worked