How can I add a calculated column in PowerBI online to an excel imported from Sharepoint

[Shrudulu]

Hi

I have a PowerBI online report which uses as data an excel file which is loaded from Sharepoint.

I would like to add a calculated column to one of the tables from the excel file.

However, I want to add this calculated column in PowerBI online, not in the excel file.

Is this possible? If yes, can you please provide instruction how to do (or a link to a tutorial).

thank you

[v-tianyich-msft · Accepted solution]

Hi @Shrudulu ,

There is a preview function where you can enable editing the data model in the workspace setting:

You can refer to:Edit data models in the Power BI service (preview) - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[mohitkumawat]

Hi @Shrudulu ,

Create Datamart/Dataflow and Connect with Sharepoint and build reports with that Datamart or Dataflow.
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/network-related-or-instan...