Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Improving formula engine performance

I have a query that's taking 55 seconds for the FE and 1 for the SE   DAX Studio obviously gives me the SQL and SE timings, but I can't see how to either   a) see what's taking 55 seconds in the ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I'm stripping back the DAX to see how it's translated into SQL and can see that even if I'm only querying two columns - date and amouunt - the SQL generated is querying every single field in the fact table

 

I can't see a reason to query fields that aren't required. Does this indicate something wrongly configured in Power BI or Synapse?

 

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

One quick suggestion to try is to replace your second variable

 

 VAR __DS0FilterTable2 = 
    FILTER(
      KEEPFILTERS(VALUES('bonus_applications_details'[is_eligible_for_bonus])),
      NOT('bonus_applications_details'[is_eligible_for_bonus] IN {0,
        BLANK()})
    )

with

VAR __DS0FilterTable2 =

Filter(Keepfilters(values('bonus_applications-details'[is_eligible_for_bonus])), 'bonus_applications-details'[is_eligible_for_bonus]>0)

 

Also, can you post the original measure from Power BI, not the MDX from DAX Studio?  I'm not confident that will make it clearer but worth a try.

 

Regards,

Pat