what if parameter direct query

[Nikki]

Hi

does the new august update what if parameter not work on direct query?

please advise

Nikki

[Anonymous]

Does it still not working on direct query ? 

[v-jiascu-msft]

@Nikki

Hi Nikki,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[v-jiascu-msft · Accepted solution]

@Nikki,

Hi Nikki,

According to my test (Sql Server DB), the What If parameter isn't available in Direct Query mode. What if parameter creates a new table actually, while no new table can be created in Direct Query mode. Maybe this is one part of the reason.

Best Regards!

Dale

[Nikki]

thanks Dale - not ideal but at least we know now. thank-you for your help.