Forum Discussion
Power BI Server
- 1 month ago
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
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.