Different excel files as source!How to manage?

[Anonymous]

Hi,

I have several reports in a power bi file (.pbix),and all of my reports have separate data source files (excel).I want to publish this but it does not allow me to do this and prompting error  "can't publish,because it includes composite model". Please help me to publish this  and also guide me how I can take sources (all excel files).

[v-yuta-msft]

Hi pundiv01,

I'm afraid you may wait for the Oct update. A same thread has been posted here: https://community.powerbi.com/t5/Desktop/Publishing-Composite-Model/td-p/482858.

Regards,

Jimmy Tao

[Anonymous]

HI @Anonymous

When you say all of your sources are excel, then your model is not composite unless you selected different storage mode. Could you please do this?

File > Options and Settings > Options > Preview Features, then select the composite models checkbox.

Thanks
Raj

[Anonymous]

Its already been checked.

[Anonymous]

Edit : Composite Models cant be published to power BI service while its in preview  as such. Please check the below post for work around.

Thanks
Raj

[Anonymous]

Hi @Anonymous

Check what makes your model is composite model. SInce all of your sources are imported model, i hope you may have included Many to Many relationship.

If thats the case , The work around is - remove the direct M:M joins and handle that scenio by including a relationship/ bridge table , that makes your model as non- composite model and you will be able to export this to Power BI Service.

Also, dont forget to uncheck the composite model preview and make sure the suorage method for all excel is set to import.

Useful Link : https://community.powerbi.com/t5/Issues/Unable-to-disable-Composite-models/idc-p/482033#M30066

Let me know if that works for you.

Thanks

Raj