Options/Query hints in DAX

Question

Are there any options or query hints available in DAX to query a specific partition in an Azure analysis services tabular model table partition. This answer to this question helps us to consider whether including any specific column for partitioning will effect query performance.

Answer 1

Hi @Raja Mallela ,

Welcome to Microsoft Q&A forum and thanks for reaching out.

Unfortunately there are no Options/Query hints available in DAX. Having a filter can help in general (they will typically propagate to the storage engine). But there’s no hints in DAX.

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

.