Forum Discussion
Table name change causing relationship error. Does anyone know how can I debug this?
I started getting this error as soon as I changed the name of the table in Power Query Editor. I am unable to find what relationship is this referring to. Can anyone please help on this error?
3 Replies
Add the column [FISCAL YEAR] back into your dimYear table, or delete the relationship.
Thank you so much for helping out. Apparently, I had to change the name of the dimYear table to Fiscal Year and then I was able to change the name of the table that was referencing to dimYear. But, this deleted all the relationships and PBI set it as a new table. I had to establish all the connections and build visuals again.
Hi pbi_20 ,
The possible causes of incorrect table relationships after the table name is changed are as follows.
- Other queries or data models that depend on the table may not be updated synchronously.
- When the table name is changed, the original reference may become invalid, resulting in a reference error in the query or data model.
There are a few methods for your reference.
- After you change the table name, make sure that all queries and steps that reference the table are updated.
- After modifying the table name, click "Refresh Preview" on the "Home page", then click the table with yellow error, select "Go to Error", and finally select the newly named table in the navigation interface.
If the error still exists, I recommend that you keep the original table name as lbendlin mentioned.
Best regards,
Mengmeng Li
