Dataverse connector should have an checkbox for "Include relationship columns" as SQL have

Hello,

I've recently ran into an issue related to Microsoft's most recommended storage in Power Platform - Dataverse. Moreover, our company uses Dynamics CRM so Dataverse becomes preferred data store.

But, trying to get the usual tables like Account, Opportunities, Systemusers, etc, recently become a tedious task because Power Query is no longer able to display a simple preview of the table.

The error: "Preview.Error: The type of the current preview value is too complex to display."

Usually, for "known tables" I will not wait for a preview. Just check the checkbox for that table and start "Transform Data". But here is the same error. (unfortunately this Idea section does not let me include pictures)

So no way to use even the single step of transformation that will let me reduce the size of the model: "choose columns".

After I have opened a support ticked, the engineers came with a workaround: manually edit the query and add an option that would ignore the relationships of the table:

Source = CommonDataService.Database("msdefault.crm.dynamics.com", [CreateNavigationProperties=false])

So, in this case, I would like Microsoft modify Dataverse connector, to have the same options like the SQL connector: after choosing "Transform data" in the screen that appears immediately after, and will let me choose either Import or DirectQuery there is in the "Advanced options" a checkbox:

Include relationship columns

So please add this option to the Dataverse connector so I will not be forced to manually edit the query from the very beginning.

But thank you that with this issue, you let me teach my PL-300 students some more "tips & tricks" (or workarounds). ;-)

Kind Regards,

Lucian Constantin.