Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
anandav
Skilled Sharer
Skilled Sharer

Compsoite model in new version of Power BI desktop

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.

 

1 ACCEPTED SOLUTION
v-huizhn-msft
Microsoft Employee
Microsoft Employee

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

View solution in original post

2 REPLIES 2
v-huizhn-msft
Microsoft Employee
Microsoft Employee

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

Thanks a lot Angelia( @v-huizhn-msft)

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors