Forum Discussion
Displayname for Dataverse field
In the july 2022 version of Power BI it was announced that you can see the display name in Power BI of a dataverse-field, instead of the technical name: https://powerbi.microsoft.com/en-my/blog/power-bi-july-2022-feature-summary/#post-19945-_Toc108099843
Unfortunately this doesn't seem to work very good ...
Today I got two failing dashboards, working on the same Semantic model, with the following error (online dashboard):
And in the dashboard (pbix) itself:
Here is the situation:
- I have a Dynamics CRM with an "accounts" table with a field "nrq_enterprisenumbers_numbersonly".
- I have imported this field in a Power BI Semantic Model, and in Power Query it's visible as "nrq_enterprisenumbers_numbersonly".
- When I go to the Power BI design, the field is renamed as "Enterprise Number (numbers only)", the same display name as is used in Dynamics for the English language.
- I have created two reports that depend on this semantic model, published them, and they are used for already several months
- Today, someone decided to rename the field in Dynamics as "Enterprise Number ( numbers only)" (A space after the bracket). Probably not intended, but for some reason this change made it through the production-process, and the change of the displayname was pushed in production environment.
- And now those two dashboards can't find that specific field anymore ...
So: How can I make sure that Power BI just uses the "nrq_enterprisenumbers_numbersonly", so the technical name of the field. Those names won't normally change anymore.
(Also notice that when you change the language of the user interface of the users that connects to the Dataverse, all display names are changed to that specific language! In my opinion that is also a very strange behaviour, since I'm not able to change that language anymore, or all my dashboard will suddenly fail!)
1 Reply
- AnonymousNot applicable
This looks like an issue as the behavior is different from the expected behavior introduced in the feature summary article. I will do a test to check whether I can reproduce the same result. I will let you know once I have any update. Thank you for your patience.
Best Regards,
Jing