Tables in PowerQuery editor do not reflect PowerBI data model using Dataverse connector

[bhalicki]

I have imported a table from Dynamics using the Dataverse connector.  I have transformed one of the tables in PowerQuery, which includes renaming the columns.  When I view the table in PowerBI data model, some columns reflect the display name.

Clearing the cache and reimporting the data does not help.

This appears to have started in May 2023. 

September 2022 is fine, April 2023 is fine, May 2023 is broken, June 2023 is broken.

[bhalicki]

Hi @EAD , I have added some more comments on this issue here:

https://community.fabric.microsoft.com/t5/Issues/Dataverse-Columns-Renamed-in-Power-Query-Show-Displ...

For anyone else following this issue, Microsoft appear to be responding to issues and classifying them as "delivered". This doesn't necessarily mean that the issue is actually resolved - it appears this means that they have "delivered" a response and no need to follow up. Very misleading for anyone who is trying to understand why their report is behaving the way it does.

[bhalicki]

Hi all,
I have raised a support ticket with Microsoft to hopefully have this fixed again 🙂

Kind regards,

Ben.

[bhalicki]

Hi all,

For anyone else who comes across this, there is a hidden (undocumented?) feature in the connector to disable this functionality:

In PowerQuery, modify the initial 'Source' step, adding EnableDisplayNames=false parameter.
= CommonDataService.Database("yourconnection.crm6.dynamics.com", [EnableDisplayNames=false])

Kind regards,
Ben.

[AndrewZ]

Thanks for that Ben. I thought I was going to have to re-invent the model with silly work arounds but your fix has brought back some hope.