cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SamRock Frequent Visitor
Frequent Visitor

Performance Impact with Calculated Columns

Hi All,

I am new to PowerBI. Being a Excel user, I know that using lot of Formulas sometimes impacts the performance. Is it the same case with PowerBI? I looks for a similar topic, but could not find any response.

Are my calculated Columns, "calcuated" dynamically? Or stored within Cache as soon as its imported? I have about 1Million+ rows, and use calculated columns to get for example: Month(Date), Create YES/NO flags based of column's values and more.

Should I precalculate these values in my SQL server DB and then import them? Does creating new Calculated values within PowerBU have any mpact on perfromance?

Does using "Custom Column" in Query Editor make any difference? How different is it from Calc column?

 

Thanks,

Sam

1 ACCEPTED SOLUTION

Accepted Solutions
mike_honey
Advisor

Re: Performance Impact with Calculated Columns

Calculated Columns are not dynamic (unless you are in Direct Query mode) - they are pre-calculated and stored.  Custom Columns from the Query Editor are similar, but the performance is marginally better.  I lean towards them for that reason but mainly because they are much easier to write, debug and test. 

 

3 REPLIES 3
mike_honey
Advisor

Re: Performance Impact with Calculated Columns

Calculated Columns are not dynamic (unless you are in Direct Query mode) - they are pre-calculated and stored.  Custom Columns from the Query Editor are similar, but the performance is marginally better.  I lean towards them for that reason but mainly because they are much easier to write, debug and test. 

 

SamRock Frequent Visitor
Frequent Visitor

Re: Performance Impact with Calculated Columns

Thank you so much for responding!
I am glad that my initial assumption were right about data getting stored! Smiley Happy
I went ahead and created all caclulated queries because the amount of data imported was already huge. People at work started questioning about the performance and thats why I wanted to get it clarified here.

 

Thank you so much! I will mark your response as Solution. Smiley Happy

 

 

"I lean towards them for that reason but mainly because they are much easier to write, debug and test. "

Did you mean Custom columns or Calculated Columns??

 

mike_honey
Advisor

Re: Performance Impact with Calculated Columns

I meant Custom Columns from the Query Editor.