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.
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?
Community ChampionAnonymous 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.