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

What If analysis option is greyed out in Power BI Desktop

ChrisDenver0603 — Wed, 07 Mar 2018 20:41:01 GMT

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!

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

deepu299 — Fri, 09 Mar 2018 20:04:13 GMT

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?

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

ChrisDenver0603 — Fri, 09 Mar 2018 20:14:05 GMT

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,

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

deepu299 — Fri, 09 Mar 2018 20:19:07 GMT

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.

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

ChrisDenver0603 — Fri, 20 Apr 2018 15:59:47 GMT

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!

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

TitikshaGanjoo — Thu, 05 Jul 2018 11:36:37 GMT

Hi,

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

Regards,

Titiksha

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

Anonymous — Tue, 19 Feb 2019 02:02:57 GMT

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!

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

Anonymous — Wed, 19 Oct 2022 20:57:41 GMT

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