Forum Discussion

luxpbi's avatar
luxpbi
Helper V
8 years ago

Power BI Desktop Extremely Slow

Hi,

The fact is that I have a not very big pbix. It's 32MB size.
I've create a calculated column, a little bit complex, but it works.

The problem is that since then the pbix is extremely slow, for example if i make any change on a mesaure or click to create a measure it will take around 15-20 minutes with the message "working on it". 
Why Power BI does that? It as no sense at all for me...
Even if the problem is the new calculated column, click on create a new measure shouldn't affect at all my report.

 

Am I missing something? 

Thank you for your help.

 

 

Regards,

Need Help

13 Replies

  • markus_zhang's avatar
    markus_zhang
    Advocate III
    7 years ago

    I found that Power BI will refresh for very small changes (like copy a value from a table, not even pasting it), and each refresh may take a long time. But 15-20 minutes is definitely too much.

    • luxpbi's avatar
      luxpbi
      Helper V
      8 years ago

      Hi v-piga-msft,

       

      They are not similar, here I'm asking why Power BI get a lot of time working on it when I select to create a new measure. 
      What is he doing there? Why a complex or not optimized DAX Measure or Column will afect that? 
      For me there is no reason for that. 
      In the other, I'm asking for a tool that can measure the performance of different DAX measures.

       

      Kumail I can't share the pbix file for security reasons but I can share with you the formula: 

      Days =
VAR CurrentProduct = 'Table1'[Product]
VAR CurrentState = 'Table1'[Status]
VAR CurrentDate = 'Table1'[Date]
VAR CurrentNMov = 'Table1'[Index_]
VAR CurrentCodTaller = 'Table1'[Type]
VAR NextStateDate =
    CALCULATE (
        MIN ( 'Table1'[Date] );
        FILTER (
            'Table1';
            'Table1'[Product] = CurrentProduct
                && ( 'Table1'[Status] <> 8
                || 'Table1'[Status] <> 9 )
                && 'Table1'[Date] >= CurrentDate
                && 'Table1'[Index_] > CurrentNMov
                && (
                    'Table1'[Type] <> CurrentCodTaller
                        || 'Table1'[Type] = BLANK ()
                        || 'Table1'[Type] = CurrentCodTaller
                )
        )
    )
VAR LastMov =
    CALCULATE (
        MIN ( 'Table1'[Date] );
        FILTER (
            'Table1';
            'Table1'[Product] = CurrentProduct
                && 'Table1'[Date] >= CurrentDate
                && 'Table1'[Index_] > CurrentNMov
        )
    )
RETURN
    IF (
        CurrentState = 8
            || CurrentState = 9;
        IF (
            ISBLANK ( LastMov );
            ( TODAY () - CurrentDate )
                + 1;
            IF ( ISBLANK ( NextStateDate ); 1; ( NextStateDate - CurrentDate ) + 1 )
        )
    )

       

      Regards,

      • Kumail's avatar
        Kumail
        Impactful Individual
        8 years ago

        Okay. Could you send sample dummy data as well?

  • Kumail's avatar
    Kumail
    Impactful Individual
    8 years ago

    Hi luxpbi

     

    Could you share your powerbi file.

     

    Probably, the calculated column needs optimization.

     

    Regards

    Kumail