cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ChrisDenver0603
Frequent Visitor

What If analysis option is greyed out in Power BI Desktop

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.

 

What-IFgreyedout.PNG

 

Thanks for your help!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
deepu299 Helper V
Helper V

Re: What If analysis option is greyed out in Power BI Desktop

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? 

View solution in original post

6 REPLIES 6
deepu299 Helper V
Helper V

Re: What If analysis option is greyed out in Power BI Desktop

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? 

View solution in original post

ChrisDenver0603
Frequent Visitor

Re: What If analysis option is greyed out in Power BI Desktop

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 Helper V
Helper V

Re: What If analysis option is greyed out in Power BI Desktop

@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. 

ChrisDenver0603
Frequent Visitor

Re: What If analysis option is greyed out in Power BI Desktop

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!

TitikshaGanjoo
Frequent Visitor

Re: What If analysis option is greyed out in Power BI Desktop

Hi,

 

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

 

Regards,

Titiksha

emilypoon Advocate I
Advocate I

Re: What If analysis option is greyed out in Power BI Desktop

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!

 

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.