2 excel with same columns, need to merge into one quiery

[Qadmin]

Hi. I am a newbi, I have 2 excel with IMEI numbers.

I have an report were the users enter there IMEi to get info for there phone.

But I unfortunately have 2 different Excel file, (all the with same tablename).

I have both Excel i PBI but I cant get the query ritght so it makes the quyery in both excel files and show them i the report.

So 2 Excel files

5  same named table, IMEI, Name, age , model End date.

I want all this in my report. The user should be able to enter the IMEI and get all the info, nometter what file the info is in.

I tryed to merged an queri as new. But it does not work.

[v-jingzhang · Accepted solution]

Hi @Qadmin 

According to your description, Append queries feature should work. However before appending, you need to ensure that both queries are in the same format with same column names.

Sometimes when there are strings outside of a table range in an Excel worksheet, the table may not be correctly recognized in Power Query. In this scenario, you need to remove unnecessary columns and rows to remain only the table range you want.  

Another option is to select the table range in Excel, then use Insert > Table. This could convert this table range into a table in the Excel file. When you connect to this Excel file, this table will appear in the Navigator window and it has the correct format. 

As long as all queries are in the correct format with same column names, you can use Append queries feature to bring all of them into the same query. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Qadmin · Accepted solution]

I hade to name the columns the same and then use append. I used Merge. So With Append it worked fine, Thanks

[v-jingzhang · Accepted solution]

Hi @Qadmin 

According to your description, Append queries feature should work. However before appending, you need to ensure that both queries are in the same format with same column names.

Sometimes when there are strings outside of a table range in an Excel worksheet, the table may not be correctly recognized in Power Query. In this scenario, you need to remove unnecessary columns and rows to remain only the table range you want.  

Another option is to select the table range in Excel, then use Insert > Table. This could convert this table range into a table in the Excel file. When you connect to this Excel file, this table will appear in the Navigator window and it has the correct format. 

As long as all queries are in the correct format with same column names, you can use Append queries feature to bring all of them into the same query. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.