I created a PowerBI workbook with a single data table a from Snowflake database. I made a chart/visualization that was two columns wide with many rows. I published this and then made a new report(same two column view) in the web editor utilizing the just published dataset as the source. There is one dataset and report with the same name and one report with a new name now. I go back to the desktop and change the name of both of the columns that feed into my chart/visualization and republish it. The report with the same name as the dataset correctly updates and the report with a different name gets this
Something's wrong with one or more fields. Fields that need to be fixed. Something's wrong with one or more fields: ('data table') 'Old column name'. Something's wrong with one or more fields: (data table) 'Old column1 name', (data table) 'Old column2 name' Please try again later or contact support. If you contact support, please provide these details.
- Activity ID: *****
- Request ID: *****
- Correlation ID: *****
- Time: *****
- Service version: 13.0.19040.38
- Client version: 2209.1.13144-train
- Cluster URI: *****
Am I doing something wrong or are reports built off of published datasets meant to break if the dataset needs to be updated?
On a similar note, if I try to open the second report in the desktop and update the dataset that way a whole new dataset and report are created when I publish them and nothing happens to the original dataset or the two reports that were connected to it.
I can see a case in the future where many people would have built things off of a data model I produce and one or two small tweaks to the dataset causes mass errors with many people not understanding how to correct the problem since this is what it looks like to them.
