Forum Discussion

LocNguyen's avatar
LocNguyen
Advocate I
6 years ago
Solved

PBI desktop does not pull full data from dataflows

Hello,   I ran into an issue today regarding pulling data from Dataflows.   I tried to import data from Dataflows into my PBi Desktop. Unfortunately, there is one column completely blank (the oth...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    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.

     

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi LocNguyen ,

 

did you map the data flow to a CDM (Common Data Model) standard entity?

I think the "_display" fields are looked up in another entity.

 

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.

  • LocNguyen's avatar
    LocNguyen
    Advocate I
    6 years ago

    mwegener 

    Yes I mapped it from Microsoft Dynamics CRM. Please see the query below:

     

    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_display", "psa_name", "psa_regionid"})
     
    The column is just one of the default columns that I selected from the entity.
    • mwegener's avatar
      mwegener
      Most Valuable Professional
      6 years ago

      Hi LocNguyen 

       

      try this

       

      Source = Cds.Entities("https://ebs1.crm.dynamics.com", [ReorderColumns=null, UseFormattedValue=true]),

      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.