Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Common Data Service Display Columns Data Showing in Edit Query but not Data?

Hi   We are connecting to an appdynamics api via a Common Data Service in Power BI and when doing so we are adding the display columns. We are finding that we can see the data within the display co...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Icey

     

    Thanks for the response, we actually found the issue with this not long after I posted the thread. It turns out that the issue was because we had removed the code columns for each of the display fields in the power query editor. As the display columns were still displaying correctly without the code columns in the power query editor we didn't think this would be a problem, but adding the code columns back in solved the issue and we can now see the display columns in the data (we then hide the code columns from the report view).

     

    For info I was using Power BI version 2.72.5556.801 64-bit (August 2019) (I've since downloaded latest version).

Icey's avatar
Icey
Community Support
6 years ago

Hi Anonymous ,

 

1. Does this issue just happen to this specific report or all reports? And do you try it again?

2. Which Power BI desktop version do you run? How about the result if you update it to the latest version?

3. Also please try to clear desktop cache then test again.

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Icey

     

    Thanks for the response, we actually found the issue with this not long after I posted the thread. It turns out that the issue was because we had removed the code columns for each of the display fields in the power query editor. As the display columns were still displaying correctly without the code columns in the power query editor we didn't think this would be a problem, but adding the code columns back in solved the issue and we can now see the display columns in the data (we then hide the code columns from the report view).

     

    For info I was using Power BI version 2.72.5556.801 64-bit (August 2019) (I've since downloaded latest version).