Unable to load data into power bi desktop from folder

Hi Suneel2429 

This could be your Query attempts to access a table or column that does not exist in your datasource. Check if there is any table/column names are not matching. Also, check sheet name, which does not exist in the Spreadsheet

Check your sample file:

Power BI uses a sample file to determine the structure of the data. Make sure the sample file is representative of all files in the folder. If the sample file is missing or corrupted, it can cause errors.

You could read this article:

https://blog.crossjoin.co.uk/2020/04/06/understanding-the-the-key-didnt-match-any-rows-in-the-table-error-in-power-query-in-power-bi-or-excel/ 

Hope this helps!!

BR,

Shafiz

Hi Suneel2429 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you!!