Forum Discussion

guillouzada's avatar
guillouzada
Frequent Visitor
5 years ago
Solved

Slow DAX Formula Bar Input (Intellisense)

In Power BI Desktop DAX formula bar text input is very slow for bigger measures (greater than 50 lines). And it gets worst with measure size increase. This is NOT the measure performance but the tex...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi guillouzada ,

    Based on my test, DAX studio works better than power bi when writing more than hundreds rows of DAX statement in this case, so I think could be a solution to help you.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Pragati11's avatar
Pragati11
Super User
5 years ago

Hi guillouzada ,

 

Haven't experienced this issues before at my end.

Is their any screesnhot you can share? Is the load time for formula bar taking a lot of time?

 

Thanks,

Pragati

guillouzada's avatar
guillouzada
Frequent Visitor
5 years ago

Actually this is slow while typing the text. The time to load the formula bar or accepting changes (click ok/enter) are fine.

 

Here's a video of the issue.

https://youtu.be/gAA7twz8yG0

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi guillouzada ,

     

    This seems to be more like the issue regarding volume of data behind your Power BI file.

    What size of data are you working with?

     

    • guillouzada's avatar
      guillouzada
      Frequent Visitor
      5 years ago

      @Pragati11 ,

      Thank you for helping me. Really appreciate 🙂

      If I create a new measure or even a new column with few lines the formula bar runs smooth and fast.

      The main problem is with the calculated table formula that has 1500+ lines.

      This table has only 731 rows. And it's a calculated table.

      Here's the pbix file properties:

      guillouzada_0-1600876534750.png

      Best regards,

      Guilheme

      • Pragati11's avatar
        Pragati11
        Super User
        5 years ago

        Hi guillouzada ,

         

        Just thinking now if is it really right to create a 1500+ lines of DAX code for a calculated table in Power BI.

        What's the requirement that is making you do that?