Forum Discussion
Kudo KingpinComposite models irreversible
I am facing issues with Composite Models in the new July:
1. Turning on composite models seems to be an irreversible switch that you can't remove which in turn means no more publishing to the service unless you have a copy of the file:
a. Added direct query tables from ASQL source to an import model. Worked initially (although the relationship behavior is getting weird unnecessary, inactive links (many m:m) are introduced.
b. Then wanted to switch back with the "set import mode for all tables". Turned off "composite models" option in PBI. c. When I restart with my pbix with tables set back to import I am getting told this model requires "composite mode" and I can't open without that being activated. Checked all tables none of them is set on dual or direct.
Would appreciate your feedback if these are problems just on my end or general issues.
Martin
I've got the same problem. I can't publish any of my dashboards since this preview feature is activated, even if there's no combination of DirectQuery data connections. Do you know what can we do?
Thanks
Best Regards
Omar Sierra
Hi there karaoan, I've found a solution for this issue. Hope it works for you.
https://community.powerbi.com/t5/Issues/Unable-to-disable-Composite-models/idc-p/482033#M30066Best Regards from Mexico
Omar Sierra
7 Replies
Hi there karaoan, I've found a solution for this issue. Hope it works for you.
https://community.powerbi.com/t5/Issues/Unable-to-disable-Composite-models/idc-p/482033#M30066Best Regards from Mexico
Omar Sierra
Are there any other options? I have a report that requires Many:Many relationship (as all others fail and PowerBI disallows them).
This is going to cause a huge delay if I need to rebuild this entire report another way.
v-yulgu-msftMicrosoft Employee
Hi karaoan,
Since composite models is still a preview feature, there existing some limitations:
It is not possible to publish composite models to the Power BI service.
Changing a table to Import is an irreversible operation, it cannot be changed back to DirectQuery, or back to Dual.
Reference: Power BI new feature: Composite models
Best regards,
Yuliana Gu
- karaoan
Thanks v-yulgu-msft, I am familiar with the limitations of composite models but this doesn't answer my question. My problem is changing a composite model report back to standard i.e. all the data sources are in import mode.
Martin
I've got the same problem. I can't publish any of my dashboards since this preview feature is activated, even if there's no combination of DirectQuery data connections. Do you know what can we do?
Thanks
Best Regards
Omar Sierra
