Forum Discussion

trevb's avatar
trevb
Advocate II
9 years ago
Solved

Dreadful performance

I'm having dreadful problems with Performance on my Surface Pro 3 i7.  Queries were slow so I offloaded a lot of work into DAX but that now means everybodies experience is slow as I'm not doing so mu...
  • trevb's avatar
    trevb
    9 years ago

    And now I answer my own question.

     

    Nestled in the below is this "GetEarliestFY(Projects[ProjectStartDate])".  This is calling a powerbi function that works out the earliest financial year from the provided column.  Apart from the fact that this being an function potentially has an overhead I think it is being called for every itteration of the loop along with it's compatriot.

     

    by changing this to #dates on both of those the query finished in a little over 15 seconds.  :-)  Some work to be done on this I think.

trevb's avatar
trevb
Advocate II
9 years ago

And now I answer my own question.

 

Nestled in the below is this "GetEarliestFY(Projects[ProjectStartDate])".  This is calling a powerbi function that works out the earliest financial year from the provided column.  Apart from the fact that this being an function potentially has an overhead I think it is being called for every itteration of the loop along with it's compatriot.

 

by changing this to #dates on both of those the query finished in a little over 15 seconds.  :-)  Some work to be done on this I think.