DirectQuery Calendar bug. Can't do many-to-one relationship.

[michal089]

Hi!

Recently I've found certain bug in PowerBI Desktop. Firstly I'm getting data from SQL Database via DirectQuery. The table has date value (e.g CreateDate ). Secondly, I have that DAX table that serves as Calendar. The thing is: I can't make a many-to-one relationship between the table from database and DAX table by date. I've tried creating calendar using M but that didnt work aswell.

On the other hand, using Import (instead of DirectQuery) I am able to make such a relationship using both DAX and M as my Calendar.

DAX formula for creating Calendar table:

Calendar = CALENDAR(min('Table1'[CreateDate]),TODAY())

Any ideas? Any help would be much appreciated.

Michal

[SteveCampbell]

This is a limitation of direct query:

Calculated tables are not supported: The ability to define a calculated table using a DAX expression is not supported in DirectQuery mode.

Please see: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

[michal089]

I am using Composite Mode which , theoretically should be capable of doing both DirectQuery and Calculated Tables. Am I wrong?