Unanswered

Entity lookup fields are not visible in DataFlow integration

(0) Share

Report

Posted on by Tin

Hello Team,

I came up with a scenario while doing CSV file integration using DataFlow. While transforming the CSV data file into Power Query all the information visible perfectly, but on the next mapping wizard in the target CDS entity we are unable to get few Lookup fields. Anyone can please help me.

Please find below is the custom entity structure:

TargetEntity
LookupField1	Visible
LookupField2	Visible
LookupField3	Visible
LookupField4	Not Visible
LookupField5	Not Visible
BooleanField	Visible

Power Query Mapping SnapShot from the attachment.

Thanks,

Rahul

Categories:

Power Automate

2020-10-01_15h19_...

All responses (2)

Answers (0)

Suggested answer

IanJB 91 on at

Like (0)

Report

Entity lookup fields are not visible in DataFlow integration

This is really old, but in case anyone else stumbles on this post with the same problem like I did - a likely issue is that the table on the other end of your LookUp doesn't have any Keys defined. This is mentioned ever so briefly in the below documentation page. Hope this helps!

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

Like (0)

Report

rRe: Entity lookup fields are not visible in DataFlow integration

I think it doesn't support relationships.