Error: please rebuild this data combination

[cristianml]

Hi,

I have an issue trying to update my data.. previous months I updated without this problem, but now I get this error:

This is my model:

Is summary, What I have in my Model is an APPEND Query with other tables and from that Append query I take some columns to create queries to use them as list to filter and use on visuals. 

Could you help me ?

Thanks.

[TeigeGao]

Hi @cristianml ,

It is a problem caused by that you cannot combine an external data source with another query. We will need to rebuild this data combination, for more information, please refer to this blog: https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/

Best Regards,

Teige

[cristianml · Accepted solution]

Hi @TeigeGao ,

I solved this issue by refresing the data from Edit queries.

Regards.

[szucsandras37]

@cristianml  can you please write how? I'm strugling with this.

[GiovanniM]

I think they went into Transform Data, then clicked on Refresh Preview and went to Refresh All. 
seemed to work for me, but its very hit or miss.