cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pundiv01 Regular Visitor
Regular Visitor

Different excel files as source!How to manage?

Hi,Composite_error

 

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).

5 REPLIES 5
Super User
Super User

Re: Different excel files as source!How to manage?

HI @pundiv01

 

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

pundiv01 Regular Visitor
Regular Visitor

Re: Different excel files as source!How to manage?

Its already been checked.

Highlighted
Super User
Super User

Re: Different excel files as source!How to manage?

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

Super User
Super User

Re: Different excel files as source!How to manage?

Hi @pundiv01

 

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

Community Support Team
Community Support Team

Re: Different excel files as source!How to manage?

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