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...
v-xiaotang
4 years agoCommunity Support
Hi francesco74
Go to Power Query Editor - Advanced Editor, and change the table name, then republish the pbix file.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
francesco74
4 years agoFrequent Visitor
Hi v-xiaotang ,
Report1.pbix is connected with direct query to dataset "Dataset1" published on Power BI Service and with 4 imported excel files. This is a "composite" model.
So, when I use Power Query Editor - Advanced Editor I only find the queries referring to the 4 imported excel files, but obviously I can't find the dataset connected by direct query.
I'm afraid my problem can't be solved with Power Query
Anyway, thank you for your contribution.
Francesco