Forum Discussion

Nikki's avatar
Nikki
Helper II
9 years ago
Solved

what if parameter direct query

Hi does the new august update what if parameter not work on direct query? please advise Nikki
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

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's avatar
    Nikki
    Helper II
    9 years ago

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