Combine tables not working

Question

Hi,&nbsp;I'm trying to combine two tables, with the same collumns, but powerbi is not showing the second&nbsp; table I choose.&nbsp;For example, if I combine Table.Combine ({Table1, Table2}), Table2 wont show up in power query. If I Table.Combine ({Table2, Table1}), Table1 wont show up in power query.&nbsp;&nbsp;No filters were applied, and fun fact: the second table appears in the combination outside the powerquery, but without any treatment done from it.&nbsp;&nbsp;The only event I imagine that could do this effect is that recently update i installed. Because I have other combinations, in the same file, and they are working perfectly.&nbsp;&nbsp;Does anyone know what could be happening?&nbsp;&nbsp;P.S. Also tried to review formats, collumns names and excel extensios (my data come from there).&nbsp;&nbsp;Thanks in advance!!

anonymous · Accepted Answer

Hi Sahir,&nbsp;Thanks for your reply.&nbsp;I triend the Append Queries as well, in fact it is the same as using Table.Combine in a blank consult. But it didnt worked.&nbsp;I found the problem. It was some collumns format. I had some 'date' in a sheet and 'date/time' in another. After I put all in 'dates' the combination worked!!!&nbsp;Regards

Forum Discussion

Related content

Tables combine

Combining three CONCATENATEX Measures with results from two Tables

Conditional table combine

table combine

DirectLake over OneLake with combination with DirectQuery tables