I'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?
Hi - We have investigated on this issue (using the repro steps shared) and identified it to be a bug. This will be fixed in the upcoming release in July.
Thanks
Subhajit
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
112
Share
Report
All responses (
Answers (
