The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 up in power query. If I Table.Combine ({Table2, Table1}), Table1 wont show up in power query.
No filters were applied, and fun fact: the second table appears in the combination outside the powerquery, but without any treatment done from it.
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.
Does anyone know what could be happening?
P.S. Also tried to review formats, collumns names and excel extensios (my data come from there).
Thanks in advance!!
Solved! Go to Solution.
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
Hello @raullaurindo,
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.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
123 | |
111 | |
78 | |
74 |