Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.