Forum Discussion

hans3400's avatar
hans3400
Icon for Helper I rankHelper I
3 years ago
Solved

Changes in Excel file

Hi  So I started making a repport from an excel file. To begin with it was just for testing so I just typed in a whole lot of data that I got from different places. All in all I have 10 tables in ...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , hans3400 

    According to your description, When you refresh the data , it returns the error code "The key didn't match any rows in the table".

    When Power BI Desktop refreshes, an error is usually reported because an error occurs in a step in PQ, resulting in the inability to obtain the corresponding data.

    You can click the "Transform data" in the "Home":

    Then we can go to each query and it's each steps to check if has an error.

    We need to solve all the error code in the Power Query Editor so that we can refresh our data in Power Bi Desktop.

     

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi , hans3400 

According to your description, When you refresh the data , it returns the error code "The key didn't match any rows in the table".

When Power BI Desktop refreshes, an error is usually reported because an error occurs in a step in PQ, resulting in the inability to obtain the corresponding data.

You can click the "Transform data" in the "Home":

Then we can go to each query and it's each steps to check if has an error.

We need to solve all the error code in the Power Query Editor so that we can refresh our data in Power Bi Desktop.

 

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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