Forum Discussion

GQ00's avatar
GQ00
Icon for Helper III rankHelper III
3 months ago
Solved

Matrix performance - w/ field parameters takes 5x longer

Hi   I've created a matrix, with has a field parameter as values. The matrix takes 23,000ms to load when all parameters are selected, based on performance analyser.   The same matrix but with all...
Need Help
  • v-achippa's avatar
    v-achippa
    3 months ago

    Hi GQ00,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you Praful_Potphode, krishnakanth240 and Kedar_Pande for the prompt response.

     

    Thank you for the update. At this point, I would recommend comparing the generated DAX queries and server timings in the DAX studio for both the scenarios. This will help identify where the additional execution time is being spent and whether the difference is due to the query plan, measure evaluation or visual rendering.

    Please feel free to share the results if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa

  • GQ00's avatar
    GQ00
    2 months ago

    Hi Anjan, we can close this. 

     

    I've removed the field parameters and left a visual with dax measures only.

     

    Not ideal, but solves the long duration issue.

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
3 months ago

Hi @GQ00,

 

We wanted to kindly follow up to check if the response I have provided for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

GQ00's avatar
GQ00
Icon for Helper III rankHelper III
2 months ago

Hi Anjan, we can close this. 

 

I've removed the field parameters and left a visual with dax measures only.

 

Not ideal, but solves the long duration issue.