Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi,
Is the limitations on Time Intelligence functions removed when Composite Model is enabled?
Most Time Intelligence functions state "This DAX function is not supported for use in DirectQuery mode".
The option "Allow unrestricted measures in DirectQuery mode" under DirectQuery option disappears when Composite Model is enabled.
Is there more details available on this?
I have read the Power BI docs on the three new features - compsite mode, manay-to-many and storage mode.
Solved! Go to Solution.
Hi @anandav,
>>Is the limitations on Time Intelligence functions removed when Composite Model is enabled?
The limitations are still there in Direct Query, and time intelligence capabilities are not available in DirectQuery based on this official article.
>>The option "Allow unrestricted measures in DirectQuery mode" under DirectQuery option disappears when Composite Model is enabled.
As I tested, the "Allow unrestricted measures in DirectQuery mode" disappears turely. Please refer to this case for more details.
Thanks,
Angelia
Hi @anandav,
>>Is the limitations on Time Intelligence functions removed when Composite Model is enabled?
The limitations are still there in Direct Query, and time intelligence capabilities are not available in DirectQuery based on this official article.
>>The option "Allow unrestricted measures in DirectQuery mode" under DirectQuery option disappears when Composite Model is enabled.
As I tested, the "Allow unrestricted measures in DirectQuery mode" disappears turely. Please refer to this case for more details.
Thanks,
Angelia