Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Why does PowerQuery not recognize my imported tables?

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 🙂 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    Any updates?

    Best Regards,
    Eyelyn Qin