PBI desktop does not pull full data from dataflows

Hi LocNguyen ,
I remember this issue.

You must also select the base field so that the _display field is transferred.

In your case it should be the field "new_type".

Source = Cds.Entities("https://ebs1.crm.dynamics.com", null),
  #"Navigation 1" = Source{[Group = "entities"]}[Data],
  #"Navigation 2" = #"Navigation 1"{[EntitySetName = "psa_regions"]}[Data],
  #"Choose columns" = Table.SelectColumns(#"Navigation 2", {"new_code", "new_type", "new_type_display", "psa_name", "psa_regionid"})

Or you can try to use Table.Buffer to avoid query folding.

Source = Cds.Entities("https://ebs1.crm.dynamics.com", null),
  #"Navigation 1" = Source{[Group = "entities"]}[Data],
  #"Navigation 2" = Table.Buffer(#"Navigation 1"{[EntitySetName = "psa_regions"]}[Data]),
  #"Choose columns" = Table.SelectColumns(#"Navigation 2", {"new_code", "new_type_display", "psa_name", "psa_regionid"})

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.