Forum Discussion

poojik's avatar
poojik
Frequent Visitor
8 years ago

Getting correct data instead of _value

I am trying to pull data from Dynamics CRM to Power BI. When the Power BI gets connected it pulls lookup fields in the format of _AttributeNameID_value instead of exact value. How can I get exact value. 

 

There is an article that I am reading related to this issue 
 
 
I understand the concept but I wonder how to do this in power BI. I could not replicate it. I would appreciate if anybody can help me
Need Help

4 Replies

    • poojik's avatar
      poojik
      Frequent Visitor
      8 years ago

       

      Here is the screeshot. 

       

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        8 years ago

        So, those look like guid references to other tables. So, you either need to pull those tables in and relate them or you might be able to expand your column in the Query Editor and pull in the correct value. You will generally get a list of options when you expand the column and you need to pick the right one.