Dataverse Table Import to Power BI

Like (0) Share

Report

Posted on 9 Feb 2022 00:04:59 by asmabahamyirou

Hi,

I am trying to read dataverse Table using PBI. Two columns of the table are lookup column. For example FractionID and MeasureID are lookup. FractionID is really in Fraction Table and MeasureID is really in Measure Table. When import the data, FractionID and MeasureID are not displaying correctly. I figure-out that FractionID is reading the unique identifier in Fraction Table and not the column that I told him to read. Same for MeasureID.

Any idea how to solve this ?

Thank you

Categories:

Tables

Microsoft Dataverse

Capture.PNG

I have the same question (0)

All responses (4)

Answers (0)

asmabahamyirou 10 on 09 Feb 2022 at 16:11:01

Like (0)

Report

Re: Dataverse Table Import to Power BI

Hi @bipinshan I have added relationship between my tables in Dateverse when I was building them, However, the issue am facing is when I have to read these data in PBI.

Was this reply helpful? Yes No
Bipin D365 971 on 09 Feb 2022 at 14:35:31

Like (0)

Report

Re: Dataverse Table Import to Power BI

Hi @asmabahamyirou ,

Please check below link - https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-entity-lookup

Thanks,
Bipin

Was this reply helpful? Yes No
asmabahamyirou 10 on 09 Feb 2022 at 12:57:01

Like (0)

Report

Re: Dataverse Table Import to Power BI

@bipinshan the link attached is not working.

Was this reply helpful? Yes No
Bipin D365 971 on 09 Feb 2022 at 06:36:10

Like (0)

Report

Re: Dataverse Table Import to Power BI

Hi @asmabahamyirou ,

I think you need to use Lookupvalue function to fetch the fields from related table. Please see below article for the same -
https://www.inogic.com/blog/2018/10/working-on-lookup-field-of-dynamics-365-in-power-bi/

Regards,
Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/
Kudos and Accept my answer if helpful!

Was this reply helpful? Yes No