** BUG ** Merging and Expanded losing data in existing columns

[Wouter]

Wauw, really need your help.

Please see screenshots:

Picture 1: Table, 4 columns: Oppertunityid is Unique

Picture 2: Expanding column UG – Systemusers – Selecting one column “Fullname”

Picture 3: Fullname gets displayed…. BUT.. columns Statecode_display an statuscode_display get NULLED ??? WHAT?..

Tried some ( al lot) things already

• This is not only in preview of the result in the query builder
• Tested it in BI dataflow en PowerBI Desktop
• Setting a filter to show only top 10 rows makes the problem disappear – but of course that’s not an option.
• Source is Dynamics 365 CE
• Messing around with the column order makes no difference.
• Number of columns that get expended makes no difference.

Would be great if someone could help keeping me sane ??

Have a great day.

Kr Wouter K

[v-cazheng-msft]

Hi @Wouter 

May I know whether there are some null values in these columns in your data source? If you untick 'blank' for 'statecode_display' and 'statuscode_display' column or sort these columns by decending , will you see those nonblank values in these columns? 

Best Regards,

Community Support Team _Caiyun

[Wouter]

Thanks for your reply.

I understand your request.  There are no null values in both collumns (in the whole dataset). The first column (opportunityid) of the table is unique and sorted.  If you look at picture 1 and 3 you will notice that we are looking at the same 10 opportunityid's. 

I'm starting to think  it's has something to do with the Common dataverse connector in combination with display collumns.The dataverse Table "opportunity" in the backend only stores the statecode en statucode. The PowerBI Dataflow connector adds the display columns to make it easy for us so we do not have to lookup all the display names. This works really well in most cases, I'm getting the feeling that with large dataset or some powerquery actions the retrieval op te display columns gets lost.??