Forum Discussion
DAX Query Performance Issue Help
So we can't really tell much about the query structure with out the full picture of the server timing window.
how many SQL subclass are being generated?
do you have CALLBACKS? etc
from what I can see you are spending way too much time in the formula engine. How big and how many columns is the Inv_Fact_Inventory table? if it is large you could consider building a temp table on the fly with only the columns you need pulling in specific columns as necessary from related tables. then write your queries to hit that temp table.
So we can't really tell much about the query structure with out the full picture of the server timing window.
how many SQL subclass are being generated?
do you have CALLBACKS? etc
from what I can see you are spending way too much time in the formula engine. How big and how many columns is the Inv_Fact_Inventory table? if it is large you could consider building a temp table on the fly with only the columns you need pulling in specific columns as necessary from related tables. then write your queries to hit that temp table.
Building temp table with required column helped to achieve desired performance.
Thanks for your inputs.