Forum Discussion
Measure Name already exists while no double names
v-luwang-msft Thanks for your time testing it. I was able to solve the problem. In PowerQuery Editor, I changed the columns name from ColumnA to ColumnAHidden (so that it matches the renamed col name in the reporting view). This solved the problem.
Still feels very strange that I only got the error when adding a non-related table. Seems like a bug.
Community ChampionAnonymous Is there a measure with the same name as a column that has a home table of that column? Or is the new table name the same name as an existing measure?
Greg_Deckler , thanks for your message. No the table name is not the name of a measure. I changed the name of the table already a few times in PowerQueryEditor and got no different result. When I look in the search field the measure name (that is shown in the error), I only find the measure in the table that is also shown in the error message.
When I open PowerQueryEditor again, delete the newly added table and do a total refresh again, I do not get the error message anymore, so I am pretty confident it has to do something with the table.
Is it possible that the table creates relationships with other tables that create this error?
- Greg_Deckler
Anonymous No, the relationships shouldn't matter. You can turn off the auto-recognition of relationships though and try it. Maybe you used a reserve word for the table? Hard to say. You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".Greg_Deckler , when looking more into detail in the PowerQueryEditor, I found the following:
In PowerQueryEditor, table X has a column with name 'ColumnA'.
When the PowerQueryEditor is closed, and I search for the column in the reportview, I see that it is renamed 'ColumnAHidden' inside the report view. A measure 'ColumnA' is then created with 'ColumnA' = SUM('ColumnAHidden').
Is this something that can give a problem? That the columnname in the PowerQueryEditor is the same as the measure name (='ColumnA'), eventhough the column name is renamed outside PowerQueryEditor ('ColumnA' --> 'ColumnAHidden')?
As the name says itself, the 'ColumnAHidden' is hidden in the reporting view (although this probably does not matter).
However, this naming was always the case when refreshing, and I only received an error message when adding a table that had no link to the table X that I mentioned above.- Greg_Deckler
Anonymous Hmm, let me see if I can replicate it.