Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Nikki
Helper II
Helper II

what if parameter direct query

Hi

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

please advise

Nikki

1 ACCEPTED SOLUTION
v-jiascu-msft
Microsoft Employee
Microsoft Employee

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

 

what if parameter direct query.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Does it still not working on direct query ? 

v-jiascu-msft
Microsoft Employee
Microsoft Employee

@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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-jiascu-msft
Microsoft Employee
Microsoft Employee

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

 

what if parameter direct query.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.