This bit me today. The Common Data Service connector requires the original coded field from CDS to be included in the query in order for Power BI to consistently import the description for the field.
For example, when importing Accounts from Dynamics using CDS, in order to get the statuscode_display field to consistently populate, statuscode must be included in the query. If statuscode is removed in the query editor, the statuscode_display will still show up in the query editor, but will it will be NULL when importing into Power BI. Unfortunately, this behaviour is not consistent and some field that had the code field removed worked and many others did not. With enough refreshes or manipulating the query, eventually all fields where the code field was removed started displaying NULL values.
This is not so much a question as a suggestion to fix. The workaround is to include the code values, but it's a huge pain to then go and hide all the code values from the final Power BI report.
v-xiaoyan-msft
on:
"Sort by column" should work regardless of key col...