Share
Report
107I've set up a Power Query import to import social data as Facts along with Dimension Links linked to those Facts. The dimensions of these facts are Country and Gender.
Both Facts and Dimension Links get created as part of the import, however, the Dimension Member field on Dimension Link isn't set and it's left blank (screenshot attached). We know that this is a polymorphic lookup to Dimension Member, Country and some other entities. We've tried setting the value in different ways including:
- Setting the name of the record such as 'Male' or 'France'.
- Setting the GUID of the record
- Setting the record type and GUID such as 'msdyn_dimensionmember:F5DFC1CF-0DA3-EF11-A72E-6045BD034EE3'
None of these have worked.
Is there any other way to set the value of Dimension Members during the import?
Also, we see an additional dropdown on the mapping screen for other polymorphic lookups. Should Dimension Member have this additional selection too?
Categories:
I have the same question (0)
All responses (
Answers (
