Composite models irreversible

[karaoan]

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

Planning & Writeback in Power BI -> Acterys

[OSIERRAM · Accepted solution]

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

[OSIERRAM · Accepted solution]

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#M30066

Best Regards from Mexico

Omar Sierra

---

[karaoan]

Thanks a lot @OSIERRAM removing all the m:m joins fixed it and I can now deploy again! 

Martin

Planning & Writeback in Power BI -> Acterys

[Voyager]

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.

[Anonymous]

hi @v-yulgu-msft

is aggregations and composite model feature released or still in preview mode?. If yes in which part of monthly release it got released?

[v-yulgu-msft]

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

[OSIERRAM · Accepted solution]

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

[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

Planning & Writeback in Power BI -> Acterys