How to Get lookup name instead of lookup ID in Power BI

[Anonymous]

I'm linking D365 CRM online with the power BI.

How do i get he lookup name instead of the ID?

[Greg_Deckler]

@Anonymous - So most likely you will need to bring in whatever entity that is what _vssm_company_value is pointing to. What entity is this data from? (what you are showing below)

[Anonymous]

@Greg_Deckler 

I have a "Contact"(new_contact) entity in which there is a field "Account"(new_account) which is a lookup field.

Now when i create a report i get the ID of the account field(_vssm_account_value)

Need to get the Account Name instead of the Account Id.

[Greg_Deckler]

@Anonymous - You need to bring in the "Account" entity then into your data model or merge it in Power Query. Are these the standard Contact and Account entities in CRM or something custom?

[Anonymous]

@Greg_Deckler These entities are out of box enities also we have custom entities as well from which we need to get the values.

[Fowmy]

@Anonymous 

Not clear about your question. Provide some sample data and the expected result with more and clear explanation.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn