Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Combine tables not working

Hi,   I'm trying to combine two tables, with the same collumns, but powerbi is not showing the second  table I choose.  For example, if I combine Table.Combine ({Table1, Table2}), Table2 wont show...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Sahir, 

    Thanks for your reply. 

    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. 

    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!!! 

    Regards

Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
2 years ago

Hello Anonymous,

 

If Table.Combine continues to fail, try using "Append Queries" in Power Query as an alternative method to combine the tables. Also, ensure there's no issue with the source files themselves, especially since they're Excel files. Sometimes hidden formatting issues in Excel can cause problems in Power BI.

 

Should you require any further assistance, please do not hesitate to reach out to me.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Sahir, 

    Thanks for your reply. 

    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. 

    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!!! 

    Regards