I am trying to find the way how to create Virtual Table relationship to native Dataverse table. The scenario is to connect external assets to Account table.
In external source I to not have GUID for Account. I have Account Number that represents unique value in external Assets table to the Accounts. In Dataverse I have also Account Number column in Account table. I created Alternate Key for this scenario in Account table (as this is pretty much effective in Data Flow mappings), but I am not able to establish the relationship between Assets virtual table and Account (basically to create lookup to Account table).
I can provide more details, but I am wandering if this is even possible. Any thoughts would be helpful.
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.
2
Share
Report
All responses (
Answers (
