cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
paruchuri447
Resolver I
Resolver I

slow performance with Calculated column

 

Hi Community,

 

I am having slow performance with below calculated columns. Both calculated columns is in the same table. PNumber column is in another table and servicename is in another table, Link is also in another table. I used related function to copy these columns and pasted it in the Table-1 and then written below DAX expression. 

 

Service = CONCATENATE(Table-1[PNumber],Table-1[ServiceName])

 

ID =CALCULATE(CONCATENATEX(Table-1,Table-1[ID],","),FILTER(Table-1,Table-1[Service]=EARLIER(Table-1[Service])))

 

Link_ID = CONCATENATE(Table-1[Link],Table-1[ID])

 

Please help me to solve the performace issue.

 

Thanks,

Paruchuri

2 REPLIES 2
niasha
Advocate III
Advocate III

It seem Microsoft has limited Power BI desktop processing power so developers do not use complex dax.

Power Bi provides a limit for storage (10GB) but not processing power yet.

 

They need to clarify howmuch processing power are allocated to calculate dax formula on cloud for each report.

I noticed that it takes even loger after recent Power BI updates. 

They try to reduce processing power on desktop so they can manage processing power in cloud with less cost.

 

You can use SSAS to porcess data before moving it to Power BI. Then you can use less complex dax.

 

 

 

v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @paruchuri447,

 

The bad performance may not only caused by your calculated column. Many factors may result in the slow performance, such as your data  model or the complex of your dax formula.

 

To get the best performance, you could have a lohislook at this article.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors