Why is it not possible to Publish a report that is developed using composite model?

[AamirShah23]

I am trying to publish a report that i have developed using composite model with SQL backend. While publishing it i am getting the error that report can't be published to service as it is using the composite model.

[v-shex-msft · Accepted solution]

Hi @AamirShah23,

>>While publishing it i am getting the error that report can't be published to service as it is using the composite model.

Nope, that isn't error. Based on test, power bi will notice you 'publish feature disabled' when you are try to publish report with 'composite mode' 'direct query' datasource.

I think it means power bi service current not support to analysis 'many to many' relationship on directquery datasource, you can switch connection mode to import model to re-active publish feature.

Regards,

Xiaoxin Sheng