Forum Discussion

Yash_Ghosh's avatar
Yash_Ghosh
New Member
3 years ago

Power BI Dashboard Error

Hello All,

 

I have been shared a .pbix file, but when I am trying to open the file, it gives me an error as - The Key didn't match any rows in the table.

I have attached a screen shot of the same. My team member is able to view the result through the same .pbix file where as I am not able to see the result. Requesting to suggest the best options available for me to resolve this issue.

 

Error in PBI

 

Thanks and Regards,

Yash

Need Help

3 Replies

  • krishb1414's avatar
    krishb1414
    Helper III
    3 years ago

    Hi Yash_Ghosh  The issue is because of
     the query is trying to connect to something in the data source that has been deleted or renamed.     To fix it, you can edit the query settings and refresh the preview.

     

    Steps : 
    1) Open Power Query Editor
    2) click on Refresh Preview.

    If you are able to refresh and see the data then no issues. Otherwise you can check your data sources and connections.

    See the image for your reference..

     

     

    • Yash_Ghosh's avatar
      Yash_Ghosh
      New Member
      3 years ago

      Hello krishb1414,

       

      Thank you for your response and tried the steps mentioned by you, it still does not resolves the query.

      I am attaching the screen shot of the error when on to the Edit Querry page.

      These are the screen pages when I click on Navigation and Source in the Applied Steps column.

      Is this the same thing that you have asked me to try.

       

      Thanks and Regards,

      Yash

      • krishb1414's avatar
        krishb1414
        Helper III
        3 years ago

        Hi Yash_Ghosh , yes.
        Open adavnance editor and copy your code for not loosing your steps. Then now go to source and select the table. After that if you see data then no issue other wise you should check data source connecton and access.