Forum Discussion

Nikki's avatar
Nikki
Icon for Helper II rankHelper 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

4 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft 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
      Icon for Helper II rankHelper II
      9 years ago

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

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Does it still not working on direct query ?