Incomplete data for Table.Combine when sourced from Incremental Refresh

[Anonymous]

We are using Table.Combine to append two data sources which both use incremental refresh. As such the row count of the child table must match that of the two parent tables.

When the dataset is published to our premium workspace, the row count of the child table does not match the sum of the two parent tables. This is after performing the initial full refresh and subsequent incremental refresh on the service.

Am I configuring the Table.Combine incorrectly (esp. since I'm using incremental refresh) or is this a bug?

If it is a bug then is there an alternative in combining two parent tables with incremental refresh?

I have also tried triggering an full refresh through XMLA and was not successful.

I have cleared the data for the child table using XMLA, this was successful. I then triggered a full refresh but returned the incorrect row count.

[Anonymous · Accepted solution]

Hi Kelly,

Apologies, when I mentioned row count I meant as the result of the DAX count aggregator of the resulting tables after data refresh has completed.

I am not experiencing a technical error using Combine.Table.

The M query is also the same as what you have in your example. The only exception, I imagine, would be that my parent tables are configured for incremental refresh.

I have also investigated further and seems that Combine.Table evaluates the parent tables based on the default filter parameters for incremental refresh (RangeStart and RangeEnd). As such it seems like it doesn’t matter what the volume of data that resides in the model as this is evaluated on Power Query first.

I have also tested calculating a DAX table while using UNION and this does give the correct row count. This also seems reasonable as the evaluation of DAX refreshes comes after Power Query is complete (and other incremental refresh).

[v-kelly-msft]

Hi  @Anonymous ,

Yes,after testing,Table.Combine can only combine source tables,once I use the filtered table,it will return error：

So the method you mentioned above should the best solution.

If your issue is solved,could you mark the reply as answered to close it?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[v-kelly-msft]

Hi @Anonymous,

I dont think that the row counts' differences cause the problem,as tested here,when I combine two tables which contain different rows,there isnt any error returned.

Would you pls paste your M codes to let us check details?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!