The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have implemented a dynamic power bi semantic model creation method that will auto create semantic models based on fields that are fed to it via a SQL Query. We are also on an apps own data power bi embedded setup.
The method of creating the models and reports works great. As well as rebinding reports to the new models.
The issue I've run into is if a user creates a new report based on one of these models and renames some fields in their report to something else. Then if they have their semantic model rebuilt (which in this process creates a new model and rebinds the reports to the new models) their report will have errors on it because Power BI Doesn't like rebinding reports with renamed fields. So even though the models may be the exact same it won't find the renamed fields.
So is there a way to block users from renaming fields? I want them to be able to edit reports, add fields and do all of the other things they can do in Power BI Embedded. I just want to block them from renaming fields.
I was asking similar questions in this post but thought I should break this out:
https://community.fabric.microsoft.com/t5/Service/Rebound-Report-from-one-dataset-to-another-but-com...
Hi @Don-Bot
As far as I am aware, if the user has got their capability to edit a report, they can put in the current column name and rename it. There is no way, as far as I know, to stop them from renaming the column.