Why does PowerQuery not recognize my imported tables?

[Anonymous]

Hello, I am trying to import several tables at one time. Therfore I am using the option Get data -> more... -> Folder. I have connected my folder with PowerQuery. This worked out fine. 

Then I was trying to expand my table by clicking the symbol right to content (combine files). I selected as shown below one file in my folder.

Then unfortunately, PowerBi is only displaying the rows of the file I selected but not the other files. 

When clicking on Applied Steps -> Removed Other Columns 1, I see that PowerBi does not recognise the other tables.

All files have exact the same structure. I already tried the same process and selected different files as standard but it did not worked out. Does anyone know or can guess why PowerBi does not recognize my files as tables?

Thank you for your help! I would really appreciate it 🙂 

[Anonymous]

Hi @Anonymous ,

Any updates?

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @Anonymous ,

It seems that I could not reproduce your issue. As the screenshot shown, it's the same as yours:

Please follow @Vijay_A_Verma 's suggestion to provide more details to help us clarify your scenario.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Vijay_A_Verma]

Click on Error and post the error message here.