Forum Discussion

Suneel2429's avatar
Suneel2429
Regular Visitor
1 year ago
Solved

Unable to load data into power bi desktop from folder

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

 

Data Protection
  • shafiz_p's avatar
    shafiz_p
    1 year ago

    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

     

     

  • v-sathmakuri's avatar
    v-sathmakuri
    1 year ago

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

3 Replies

  • shafiz_p's avatar
    shafiz_p
    Icon for Super User rankSuper User
    1 year ago

    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

     

     

  • v-sathmakuri's avatar
    v-sathmakuri
    Icon for Community Support rankCommunity Support
    1 year ago

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

  • v-sathmakuri's avatar
    v-sathmakuri
    Icon for Community Support rankCommunity Support
    1 year ago

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