Much awaited, the ability to query the CDS / Dynamics 365 using SQL is now finally in Preview.
Microsoft PowerApps Office Add-in brings to the Power Platform functionality previously only available to our Dynamics 365 F&O/AX friends.
This article is not about what DES is, or how to configure it. You will find literally a thousand articles about that by running a quick search. Instead, I want to focus on some of the scenarios where this makes sense to use.
Now you can concatenate record names or any other fields from values in other fields or fields of related records in minutes. Gone are the days of custom code.