ability to rename a query item (field) in a dataset
Power BI should be able to propagate changes in fields (eg. rename of 'customer_name' to 'customer_full_name') in a dataset to all the reports using this dataset in powerbi service.
This functionality is essential if Power BI is to be used as a Self Service BI tool, which allows users to define their own reports based on the dataset.
Currently a change of fieldname will cause existing reports to fail.
possible solutions I can think of :
1. every query item is identified by an internal id, and every report refers to this internal item id (instead of the item name). When the item is renamed all existing reports will automatically use the new name (customer_full_name)
2. every query item has both an item code and an item name. A report refers to the item code, but displays the item name. The item name can be changed without causing existing reports to fail
3. other ......
Curtis Ramirez commented
This really becomes an issue when testing. I recently had a case where a new table in the dataset was being built to replace one currently used in my Power BI report. The new table had "test" in the name; once testing was finished and the "test" table was moved to live and the name changed, the whole report failed.
I was able to fix the report on the desktop sides using Query Editor, but this fix does not propagate into the Service. All visuals tied to that report were still looking for the table with "test" in its name.
Léon Rethans commented
This idea is about a Self Service BI environment with thousands of reports using shared datasets in powerbi service. Renaming a field in this shared dataset will cause all dependent reports to fail.
Your workaround won't fix this problem.
This is already implemented (in a way). If you rename the field from the Fields pane (outside of PowerQuery editor), the rename will affect everything in your report as well as add the rename step to your Query Editor. I think there are higher-value ideas than investing time in making this more robust when a workaround already exists.
Yamil Corrales commented
What happens when you activate the automatic update?
if the field no longer has the same name in power Bi as in Sql server?
I would not update the report?