Data source setting

[neha369]

Here i am encountering a situation .. 

I have built a power BI report from my sql database import  . Lets say databace is ABC and table name is hrms

Power BI is naming the table as ABC.hrms. 

I want to now change to data source from my sql database. Databace XYZ and table name hrms.

When changing the data source it is giving error as "The key did not match". 

I assume the new data source is fetching table XYZ.hrms and it is not matching with ABC.hrms. Any thoughts ??

[V-pazhen-msft · Accepted solution]

@neha369 

If both hrms tables in database ABC and XYZ have the same named columns "hrms". You need to rename the Power Bi table "ABC.hrms. " back to "hrms". It should match with the table name in XYZ database as you change the datasource.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[neha369]

Thanks for the solution guys . but here i have found the solution. Please check the below link to get the answer. 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/40300078-data-source-change-setti...

[VijayP]

you need to check the Primary and Foreing key attributes and they are similar.

[neha369]

Both the tables are replica of each other so i don't think the primary/foreign ke is making any difference here .

[nandukrishnavs]

@neha369 

You can go to Edit Query and verify the step one by one. 

Usually, this error message (The key did not match) has occurred when specified table name or column name has not existed in the specified source.

If you are confused with what I'm telling, please share the snapshot of each step?

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂