cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tamir Member
Member

Direct Query and Time Intelligence functions

Hi,

 

Power BI has very powerful Time Intelligence capabilities.  

 

However, they seem not to be applicable when using a direct query.

 

Am I missing something big?

 

What is the alternative to the Time Intelligence functions when using Direct Query?

 

Thank you

Tamir

3 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
praiselyabraham Regular Visitor
Regular Visitor

Re: Direct Query and Time Intelligence functions

Hi Tamir, 

 

The time intelligence takes a toll when connecting to direct query. 

If you are expecting the date hierarchy in specific , you would have to create it for yourself by making columns [year], [quarter],[month],[date] and then use them to create a hierarchy.

 

You can get the modelling and reporting limitaions for direct query connection in 

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

 

Regards,

Praisely

Community Support Team
Community Support Team

Re: Direct Query and Time Intelligence functions

Hi Tamir,

 

Yes, in direct query mode, time intelligence function are not available, please refer to the documentation: https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/dax-formula-compatibility-in-d.... The alternative ways depend on your specific senario, so if you want to achieve some result using time intelligence, please share sample data and expected result.

 

Regards,

Jimmy Tao

Super User
Super User

Re: Direct Query and Time Intelligence functions

Hey Tamir,

 

basically the build-in Time Intelligence functions are syntax sugar for a combination of other DAX functions.

 

Here you will find a lot of examples how to rewrite these build-in functions:

https://www.daxpatterns.com/time-patterns/

 

Regards,

Tom 

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
3 REPLIES 3
Highlighted
praiselyabraham Regular Visitor
Regular Visitor

Re: Direct Query and Time Intelligence functions

Hi Tamir, 

 

The time intelligence takes a toll when connecting to direct query. 

If you are expecting the date hierarchy in specific , you would have to create it for yourself by making columns [year], [quarter],[month],[date] and then use them to create a hierarchy.

 

You can get the modelling and reporting limitaions for direct query connection in 

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

 

Regards,

Praisely

Community Support Team
Community Support Team

Re: Direct Query and Time Intelligence functions

Hi Tamir,

 

Yes, in direct query mode, time intelligence function are not available, please refer to the documentation: https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/dax-formula-compatibility-in-d.... The alternative ways depend on your specific senario, so if you want to achieve some result using time intelligence, please share sample data and expected result.

 

Regards,

Jimmy Tao

Super User
Super User

Re: Direct Query and Time Intelligence functions

Hey Tamir,

 

basically the build-in Time Intelligence functions are syntax sugar for a combination of other DAX functions.

 

Here you will find a lot of examples how to rewrite these build-in functions:

https://www.daxpatterns.com/time-patterns/

 

Regards,

Tom 

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!