Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Complete bug report is in the title I think.
I created a connection to a Postgres table in my PBI report using DirectQuery. In DAX, I added a new computed column using the formula:
weekday = WEEKDAY([timestamp], 2)
Which gives me an "OLE DB or OBDC Error" when using the column in a visual.
However, if I change the formula to
weekday = WEEKDAY([timestamp])
or
weekday = WEEKDAY([timestamp], 1)
, the column works without any problems.
If I use Import mode instead of DirectQuery, the original formula works, too.
The workaround is obvious, but this should not happen. Hm ...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.