Forum Discussion

DCELL's avatar
DCELL
Resolver I
6 years ago
Solved

Apply query changes getting stuck (small dataset)

I have a small dataset (1115 rows, 5 columns) imported from SSMS. All my query changes have been fine so far, but when I try to add a simply conditional column and try to apply, it will get stuck he...
Need Help
  • DCELL's avatar
    DCELL
    6 years ago

    Well guys - yesterday it didn't work and today it did. I still don't know why, maybe the old pc needed a reboot. Thanks for your replies anyhow.

     

    If someone runs into the same problem in the future I guess they could try a reboot first and then see if it works 😃

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

Your post says if...else...other.  Just to clarify, do you use if ... then ... else , which is the expected M syntax?

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

DCELL's avatar
DCELL
Resolver I
6 years ago

I did not write the M code myself. I only used the dialog box that pops up below. So the code in the native query is just what PBI wrote for me.

 

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    6 years ago

    Hi DCELL ,

     

    So your issue is solved ,right?

    If so,could you pls mark the reply as answered to close it?

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!