Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Creating new column hangs Power BI

Hi,

[situation overview] I'm using lastest Power BI version on a file smaller than 10 MB.

 

When I try to create a new column on a table (142000 rows) Power BI shows the pop up white window saying "Working on it" and stops: no feedback message nor errors within hours.

 

Thanks in advance

PS. you can see from the following image the CPU usage indicator  :smileysad:

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    How about create measuare instead of the calculated column? As there are 142000 rows in one of your table.If your formula is complex it will take a lot of time to calculate. Please refer to the third-party blog to improve the performance of your data.

     

1 Reply

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous ,

     

    How about create measuare instead of the calculated column? As there are 142000 rows in one of your table.If your formula is complex it will take a lot of time to calculate. Please refer to the third-party blog to improve the performance of your data.