Changing Datasource Settings to new SharePoint list causes data load error, "The Key didn't match...

[cgillespie]

I developed a BI report that uses data stored in a SharePoint list.  I now need to duplicate this application across many different business units.  I created a template of the SharePoint list to copied that out to each business unit's subsite in SharePoint.  Therefore each list is exactly the same name and the columns are exactly the same,  The only difference is the subsite name.

I.e.

diobpt.sharepoint.com/dept1/DataList

diobpt.sharepoint.com/dept2DataList

etc...

When I change the data source in my desktop Power BI, I get the error message on Load, "The key didn't match any rows in the table."

I have to roll this out to 80 departments and I really don't want to do each from scratch!

Thank you !

[Anonymous]

Hi  @cgillespie ,

The reasons may be:

Power Query query is trying to connect to a table or worksheet or something in your data source that has been deleted or been renamed.

This is the related document, you can view this content:

https://stackoverflow.com/questions/58420438/how-to-resolve-power-bi-error-the-key-didnt-match-any-r...

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table...

https://community.powerbi.com/t5/Desktop/how-to-resolve-Power-BI-error-the-key-didn-t-match-any-rows...

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table...

Best Regards,

Liu Yang

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

[KNP]

Can you paste your Power Query code in please?

Mask/change anything sensitive.