Forum Discussion
francesco74
4 years agoFrequent Visitor
Composite model: update model after table name changing
Hi everyone! I created a composite model in Power Bi desktop, consisting of: a direct query connection to a dataset published in the Power BI service + some local excel files. Everything works very...
amitchandak
4 years agoSuper User
francesco74 , Are you using this composite model as a data file, and then using it, in a visual file?
francesco74
4 years agoFrequent Visitor
I try to explain the architecture:
Report1.pbix is connected with direct query to dataset "Dataset1" published on Power BI Service. The Report1.pbix, with a composite model, joins the connected dataset1 to 4 imported excel files (with new relationships between the dataset tables and the excel imported tables).
The pages of Report1.pbix have visuals that use fields from the composite model.
It works! Even when I publish report1.pbix
My problem is this: if I change the name of a table in Dataset1 I cannot update the composite model of Report1.pbix with this change.
Thanks for your cooperation