Multiple values error

[Eddie]

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) calculation error in measure "Measure table[Measure Name]: A table of multiple values was supplied where a single value was expected.

Again I created the same value in import mode and did not get this error. Any suggestions on how to fix this?

Thanks,

[Anonymous]

@Eddie There are some DAX functions that will not work in DQ mode. What is the measure, and what version/Database are you running it against?

[Eddie]

I'm running against Azure SQL db. The measure calculates the sum of hours from a fact table based on "reporting period from" and "reporting hours to" values.

[Anonymous]

@Eddie Did you check the data types of the values? Are they the same in the database as they are when you import? Often Power BI will choose it's own "best fit", while DQ will use what is in the database.

[Eddie]

I'll look into that. Where can I find a list of functions that are not supported in DQ?

[Anonymous]

@Eddie It doesn't initially sound like you should have issues with the function, but I there is this compatability wiki. Another quick check, in "Options and Settings -> Options -> DirectQuery -> make sure you have the "Allow unrestricted measures in DirectQuery mode" checked...