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.

[durha_]

Do you know why this is happening? I'm getting the same error but everything works fine after I refresh in the Transform Data screen. Do you have an update on if, and how, this effected those using your dashboard?

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

[durha_]

Does this affect the users at all, once the dashboard is active?

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