Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
After adding some Custom Columns to the querys of 25 tables, I get the error "Each original name must belong to the set of all names"
This is the stack trace from Power Query: https://1drv.ms/t/s!AozuErIacxzbhGAeY0O7DEv4vC9P?e=0X9VOX
Anyone know how to solve it?
Thanks.
Solved! Go to Solution.
Reenabled a table, that I had disabled and changed it's name, and the issue gone away.
I've solved this by reverting some steps on my modifications.
I've realized that the problem was happening on the moment that the model connection was being validated.
First I've tried disabling all relationships for the tables that I modified but does not changed the problem.
One of the modifications that I made was that a I had changed the name of one of my tables and disabled it. I just enabled it again, keeping it's new name, applied, and the problem is gone. Finally I disabled it again and it was ok now.
I hope this help any other having this problem.
@emillanes
Thanks for share your experience, this would definitely help people with same issue with recent versions. Let's hope the fix will be launched asap.
And an internal ICM is created regarding to this issue, I would keep follow this post for any new updates.
Paul Zheng _ Community Support Team
Best Regards
Reenabled a table, that I had disabled and changed it's name, and the issue gone away.
I've solved this by reverting some steps on my modifications.
I've realized that the problem was happening on the moment that the model connection was being validated.
First I've tried disabling all relationships for the tables that I modified but does not changed the problem.
One of the modifications that I made was that a I had changed the name of one of my tables and disabled it. I just enabled it again, keeping it's new name, applied, and the problem is gone. Finally I disabled it again and it was ok now.
I hope this help any other having this problem.
Thank you Advocate II for the lead.
The cause for me was a table name change coupled with a change in the load behavior. The solution was to identify the table that was causing the failure and to enable the load and change the name BACK to what it was. This was the tricky part.
I was able to infer which table was causing the error based on the data load status window. The error would occur when trying to load the data into the model after evaluating each query. I had a date table which I referenced as a data source for other role-playing dimensions. The date tables took the longest to validate and load. Since they were small tables and I had changed the name and load behavior, I figured that they were at least part of the issue.
One final suggestion, do not do what I did. I got lazy and cocky, made lots of changes between saves and applications of the changes. It was very hard to determine which table was the culprit. Apply each change to test them and save the file right aftewards.
Good hunting.
I had same problem.. re-enabled a table and error went away...
Problem is related to changind name from tables then changing the state of loading (enable/disable).
Power BI has an update today but this problem was not solved yet.
@bluedatenbrian - spot on for me - I tried to rename a table and change its enable/disable state at the same time and got the error. Renaming, applying & then changing its state worked without issue. No need to install previous version of PBI Desktop.
Something I've found is very helpful right now is do not rename a query in Power Query if that query is loaded to the data model. Instead, let it load with whatever name it has. Then, rename it in the Power BI Desktop side. It will push that rename back into Power Query, but won't cause this error to show up.
A fix is coming, but workarounds like this help prevent data loss. Hopefully soon.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingGreat!
Thank you for this!
This worked perfectly for me!! Thanks for posting this work-around.
Did you find any solutions?
I have the same problem.
https://community.powerbi.com/t5/Issues/Power-Bi-Desktop-Error-Message-Each-original-name-must-belon...
Not yet.
I have oppened a support ticket as @edhans said, and I'm waiting for response from Power Bi support.
Please post back with any resolution @emillanes . I'm very interested if this is a bug introduced in the latest version, as may be suggested by @Anonymous to install last months version.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingAs soon as the Power Bi support give me an answer, I will post the solution or anything they tell me
The solution given by support, was to going to a previous version of Power BI.
I installed the previous Power BI and it helped. You may try this too:
https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive?tabs=powerbi-de...
@emillanes can you please unmark that response as the solution. That is a work around. The solution will be when MS fixes this, and they are working on it.
the workaround is a good plan for now, but you cannot stay on June 2021 forever. Hopefully a new July or early August build will have the proper fix in it.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou have downgrade the version and it worked? or how?
I uninstalled the latest version and then downloaded the previous one. And yes, it worked. As described here: https://community.powerbi.com/t5/Issues/Power-Bi-Desktop-Error-Message-Each-original-name-must-belon...
Yeah, it seems to work with no more errors. This means that it's a bug introduced in newer version.
Anyway, support team has more information about this error, and if they notify me about how to solve it I will share it here.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
24 | |
12 | |
12 | |
11 | |
8 |
User | Count |
---|---|
42 | |
25 | |
14 | |
14 | |
12 |