Unable to load data into power bi desktop from folder

[Suneel2429]

Hi Team,

When I am Trying to Load data into power bi desktop through Folder path I am getting an error related to OLE DB and ODBC.
Please help me to sort out this issue.

4 Montly Sales File (Excel)

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [Expression.Error] The key didn't match any rows in the table.. '.

Transform Sample File

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [Expression.Error] The key didn't match any rows in the table.. '.

Sample File

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [Expression.Error] The key didn't match any rows in the table.. '.

Transform File

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [Expression.Error] The key didn't match any rows in the table.. '.

Query parameters

Parameter1

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [Expression.Error] The key didn't match any rows in the table.. '.

[shafiz_p · Accepted solution]

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-... 

Hope this helps!!

BR,

Shafiz

[v-sathmakuri · Accepted solution]

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!!

[v-sathmakuri]

Hi @Suneel2429 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @shafiz_p  for the prompt response.

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you!!

[shafiz_p · Accepted solution]

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-... 

Hope this helps!!

BR,

Shafiz