Options/Query hints in DAX

Raja Mallela 21 Reputation points
2021-04-28T13:57:49.97+00:00

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.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
429 questions
0 comments No comments
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 46,407 Reputation points Microsoft Employee
    2021-04-29T15:07:38.78+00:00

    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.

    .


0 additional answers

Sort by: Most helpful