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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register 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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.