Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Best Practice for Calculations (Sharepoint Calc Column Vs PowerBi)

Hi, 

 

Is it Better to run Calculations in Sharepoint via a calculated column or in Powerbi?

 

What would cause more congestion? Is there a difference?

 

Whats the best practice

 

 

2 REPLIES 2
TeigeGao
Solution Sage
Solution Sage

Hi @Anonymous ,

It actually depends on your requirement and environment, if you want to let PowerBI running faster and reduce the space PowerBI used, you can use the calculated column in Sharepoint.

Best Regards,

Teige

Anonymous
Not applicable

 


@TeigeGao wrote:

Hi @Anonymous ,

It actually depends on your requirement and environment, if you want to let PowerBI running faster and reduce the space PowerBI used, you can use the calculated column in Sharepoint.

Best Regards,

Teige


so its a give and take thing.. 

 

Ill guess ill do half the calculations in sharepoint and the other half in powerbi.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.