topic Re: How to Get lookup name instead of lookup ID in Power BI in Developer

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

Anonymous — Mon, 07 Sep 2020 06:57:41 GMT

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

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

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

Fowmy — Mon, 07 Sep 2020 08:35:36 GMT

@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

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

Greg_Deckler — Mon, 07 Sep 2020 19:42:28 GMT

@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)

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

Anonymous — Tue, 08 Sep 2020 04:48:50 GMT

@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.

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

Greg_Deckler — Tue, 08 Sep 2020 04:52:02 GMT

@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?

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

Anonymous — Tue, 08 Sep 2020 06:10:06 GMT

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