Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

OData.Feed Include Annotations from CRM

Hi    I'm trying to test connecting Power BI to our UAT Dynamics CRM and pull back a number of columns. The problem i'm having is that some columns have a CRM datat type = Option Set and what I rea...
Need Help
tyler-clark's avatar
tyler-clark
Regular Visitor
7 years ago

Anonymous 

Were you ever able to get your labels to dynamically import without DAX to replace the values?  

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Tyler-Clark, no I havent found the solution yet, I need to find some time to keep looking for it.

 

What I'm thinking of doing just to get things working is create another table with 2 columns. One with the unique CRM number and another I will have to manually maintain with the label name i want. The other option is add a conditional column and write the mapping in code. But both will require ongoing maintenance if the CRM labels change.

 

Do you have a solution or the same problem? 

  • tyler-clark's avatar
    tyler-clark
    Regular Visitor
    7 years ago

    Anonymous 
    Sadly, i do not.  I have done quite a bit of testing and using a DAX replace function and just updating it as new fields are adding or old fields are changed seem to be the only viable solution, but with nearly 300 different fields, the function is going to take me quite a bit of time to maintain.