question

rajamallela435 avatar image
0 Votes"
rajamallela435 asked KranthiPakala-MSFT commented

Options/Query hints in DAX

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @rajamallela435,

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.

.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @rajamallela435,

Following yo to see if the above info helps. Do let us know if you have further query.

Thanks

0 Votes 0 ·