Receiving The key didn't match any rows in the table when connecting the datasource again

[Jeyeline]

Hello Team,

 We are using powerbi connector to connect to the datasource in the sharepoint. But accidentally the datasource sheet name gets changed, it cause the The key didn't match any rows in the table issue.

However, if I tried to rename the file back to its original value. Still facing the same issue.

Regards,

Jeyeline

[anmolmalviya05]

Hi @Jeyeline, Hope you are doing good!

Please open power query editor and navigate to the "Navigation" Step applied in the queries pane and please validate that the corrrect name is selected.

Let me know if you have any other doubt.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[Jeyeline]

Hello @anmolmalviya05 ,

Thanks for your time. I found the issue, the sheet name and column names are modified. Adjusted the same in the query editor, now it works.

However, I would like to introduce few more columns on the same excel sheet located in a share point folder. But it causes error and the newly added columns are not updated.

Any steps to resolve the issue?

[anmolmalviya05]

Hi @Jeyeline, Thanks for your response!
Can you please share some more details about the steps applied in the query and what are the errors you are getting?

[Jeyeline]

In a sharepoint, create a folder and have an excel inside the folder.

Connect with folder connector and then point to the required sheet. Now create a dashboard in power bi desktop. Publish to service.

Now, create additional columns or modify existing columns by having new headers. Refresh the data. Error is prompted.

[SaiTejaTalasila]

Hi @Jeyeline ,

You can check this one

https://youtu.be/7oiTqK47__c?si=YYNaM-bf-zxnSHZn

Or 

Edit m query -you can load data to new table and and open advanced editor copy first few lines of query and replace them in old tables m query.It will fix the issue.

Thanks,

Sai Teja 

[Jeyeline · Accepted solution]

Hello @SaiTejaTalasila ,

Thanks for your time. I solved the issue by replacing the file in the first step of query editor and it solves the issue. Now i could get the result.