Forum Discussion

cgillespie's avatar
cgillespie
New Member
4 years ago

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

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 !

 

2 Replies