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...
Need Help
krishb1414's avatar
krishb1414
Icon for Helper III rankHelper 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
    Icon for Helper III rankHelper 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.