Answered

Is it possible to import data using PowerQuery into a Dataverse Lookup column?

(1) Share

Report

Posted on by CU08101705-0

I am currently trying to import data from Excel into my empty Dataverse tables. This is working as expected, apart from the lookup tables. I've adjusted my data so that the values in the parent Primary Lookup column of the parent table match the data that I'm trying to insert into the lookup columns of the child table, but when I try to map the columns there is no option to map the two columns that contain drop down lists. Any help would be greatly appreciated.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Fubar 8,354 Super User 2025 Season 2 on at

Like (0)

Report

Not sure if it is 100% the same, but for a Dataflow (uses the Power Query engine), to be able to map to Lookups you need to have setup an Alternate Key on the Table that the Lookup is to (i.e. alt key on parent table)

https://learn.microsoft.com/en-us/power-query/dataflows/relationships-in-standard-dataflows#when-the-field-mapping-doesnt-show-the-relationship-fields

Was this reply helpful? Yes No
CU08101705-0 14 on at

Like (0)

Report

Yes, This does exactly what I wanted it to do. Many thanks for the help. When I was searching for an answer, I was doing it from the perspective of Dataverse, so didn't find the link that you provided.

Was this reply helpful? Yes No