Forum Discussion
Composite model: update model after table name changing
Hi Francesco!
I have the exact same problem, but I found a solution, that is not great, but it working.
Here is my architecture:
- 1 golden dataset
- 1 composite model dataset that uses to golden dataset + a Onedrive excel file
- 1 report that is made from the composite model (directly on the same file as the dataset).
What changed:
>I changed the name of 2 columns in the golden dataset (and added another one)
What wasn't working:
On Desktop when I try to update the composite model, I get an error, saying there is not "old column name" in the golden dataset. I believe however that the data on the report on PBI Service was still updated (not sure cause I have another issue on the golden dataset).
How I fixed it:
I've seen that I can rename the columns in the composite model (right click ; rename).
So I renamed both columns with the new name from the golden dataset.
The composite model can now be updated.
I've noticed that the new column now appeared as well.
>My solution is not great because in case you'd make heavy changes to the golden dataset, the data doesn't follow up.
other solution ; I had tried to delete the tables that are from the golden dataset to then add again the golden dataset as a source. The problem is that once you delete the tables, Desktop asks you to apply the changes, but it won't work as it cannot find the data.