What If analysis option is greyed out in Power BI Desktop

[ChrisDenver0603]

Is there conditions to when the What If parameter is enabled vs disabled in Power BI?

I've attempted to use this using DirectQuery, SSAS Live connection and Import.  There does not seem be a dependency on the data source.  The box is at first active prior to adding a data source.  Once I have connected to any source of data.  The What If parameter becomes greyed out in Power BI Desktop (Oct 2017) optimized for Report Server.  After that, I cannot seem to get it to become active again.  I've been following blogs on how to create What If parameters.  I cannot figure out why this option is greyed out.

Thanks for your help!

[Anonymous]

Yes,The problem still exists at the latest vesrion.does anyone have a solution?

[emilypoon]

Further to the below PBI "What If" button greyed out issue, I am facing the same problem too.

I am using PowerBI Desktop February 2019 version and connecting to my live data.

Anyone knows how to solve this issue?

Thank you!

[deepu299 · Accepted solution]

Hi @ChrisDenver0603 Data Modelling like using Parameters is not allowed with Live Connections. It should be enabled when you use import option. Would you be able to use March 2018 version and see if it works? 

[TitikshaGanjoo]

Hi,

The new paramter tab is disabled in case of data import as well, pls suggest.

Regards,

Titiksha

[ChrisDenver0603]

I wanted to follow up in case someone else had this issue.

Once the March 2018 Power BI Report Server came out.  This appears to have fixed this issue.

Thank you!

[ChrisDenver0603]

Hi @deepu299,
Thanks for the help on this. 
For Power BI Report Server, I'm not aware there is a March 2018 version.  Are you referring to the Power BI Desktop for Power BI.com?
We are currently using Power BI desktop optimized for Power BI Report Server. 

thanks,

[deepu299]

@ChrisDenver0603 Yeah I was referring to Desktop. Sorry about it, I should have noticed that the question is posted under Report Server. Let's see if someone can get this.