Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

 

 

General Comment
Need Help

2 Replies

  • TeigeGao's avatar
    TeigeGao
    Solution Sage
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

       

      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.