Anonymous
1 year agoNot applicable
Status:
Investigating
Dataverse Columns Renamed in Power Query Show Display Name After Close and Apply
Description: When using Power BI with a Dataverse source, renaming columns within Power Query does not reflect the changes after hitting “Close and Apply.” The columns revert to their original names ...
edhans
Community Champion
1 year agoI do not believe this is a bug, but a feature.
See the 2022 update to the Power Query connector: https://powerbi.microsoft.com/en-us/blog/power-bi-july-2022-feature-summary/?cdn=disable#post-19945-_Toc108099843
The fix, or at least adjustment to the way it works, is to add the below to the connection line as one of the parameters.
[EnableDisplayNames=false]
I have not yet been able to test this. Waiting for my team to get back to work after the weekend.