Getting correct data instead of _value

[poojik]

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 

https://us.hitachi-solutions.com/blog/fast-vs-furious-powerbi-dynamics-crm-avoid-common-mistake-watc...

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

[Greg_Deckler]

Can you post a screen shot of what you are seeing?

[poojik]

Here is the screeshot. 

[Greg_Deckler]

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.

[poojik]

Thanks Greg for your eply. I am trying to expand coulmn and pick the right field. While doing so I am getting following error.

DataSource.Error: OData: The property '_responsiblecontactid_value' does not exist on type 'Microsoft.Dynamics.CRM.incident'.

Make sure to only use property names that are defined by the type.
Details:

DataSourceKind=OData

Here https://community.powerbi.com/t5/Desktop/Apply-Query-Changes-Error/td-p/47725 you have suggested to create a brand new file and create a brand new query in that file and is that successful or do you get the error?

But I wonder how to do this? 

Best

Pooja