Forum Discussion

bahaaa_bouakl's avatar
bahaaa_bouakl
Frequent Visitor
7 years ago
Solved

CDS option set field appearing empty

I have imported data from the a common data set custom entity to Power BI Desktop. i have a field"Approval Status" (2 options: Appproved,Rejected) which is an option set field. In the query editor,...
  • bahaaa_bouakl's avatar
    bahaaa_bouakl
    7 years ago

    Hi Amy,

    No filters on page or report level.

    I am using the exacct version you mentioned (2.68.5432.661).

     

    i refreshed the data and nothing hcanged.

     

     

    So, i downloaded the latest PBI version (2.68.5432.841), i then went to the query editor Applied Steps manager.

     

    i removed the column from the second step. i Saved. then i went again and added it. i applied and closed the query editor and VOILA!

    the data appeared.

    I am not sure whether it is the version upgrade or the "Applied Steps" mini "hack" that fixed the issue...

     

    if someone is not ready to update his PBI version, and has the same issue, maybe he should check removing then readding the column first.

     

    Thank you for your help Amy.