Power BI Server

[Soumeli]

Hi Team!Can a business user edit a calculated column and publish the report in power bi server?

[v-tejrama]

Hi @Soumeli ,

Thank you @Parchitect  for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you.

[tayloramy]

Hi @Soumeli, 

If you're talking about the Power BI Report Server (on prem) then as long as the business user has the content manager permission, then yes they can. 

If you're talking about the Power BI Service (Fabric) then the businesss user will need a pro license, and at least coontributor permissions in the workspace they intend too publish the modified report.  

[GilbertQ]

Hi @Soumeli 

If you could just confirm you are talking about Power BI Report server.

[Parchitect]

Hi @Soumeli,

Short answer: only under specific conditions — and the key thing to understand is that a calculated column lives in the data model, not the report layer. So editing one isn't a report-level action; it's a model change. Where (and whether) a business user can do it depends on the platform:

On Power BI Report Server (the on-prem server)
There's no in-browser model editing. To change a calculated column, the user has to:

• Open the source .pbix in Power BI Desktop optimized for Report Server — and critically, the version must match your server's release (Report Server ships Jan/May/Sep). A file from the regular (cloud) Power BI Desktop generally can't be published to Report Server, because its schema is newer and it may use features the server doesn't support (composite models, aggregations, etc.).
• edit the column's DAX there, and re-upload/overwrite the report on the server.

So a business user can do it, but only if they have: the Desktop (RS edition) installed, access to the source .pbix. And Publish permission (Publisher/Content Manager role) on the target folder. A pure consumer with read-only (Browser) access cannot.

Best regards,

Parchitect · Solutions Architect · Microsoft Fabric Specialist