Forum Discussion

Eddie's avatar
Eddie
New Member
10 years ago
Solved

Power BI DAX error

I created a mesasure using import mode and was able to use it in a vizualization. However, when I use the same measure in direct query mode, I get the following error: " MdxScript(Model) (1,169) calc...
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    Eddie I've seen this error happening also on directquery mode but works fine when published to service (so just ignore it in poewr bi desktop). Just make sure under File -> Options and settings -> Options -> Directquery -> you have allow unrestricted measures in directquery mode ticked. 

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

Eddie I've seen this error happening also on directquery mode but works fine when published to service (so just ignore it in poewr bi desktop). Just make sure under File -> Options and settings -> Options -> Directquery -> you have allow unrestricted measures in directquery mode ticked.