3 Must Have Tools for Dataverse Developers and Administrators ❤️

[@jeromeorbust]

Jason will be glad to know someone still using Rest Builder! I will let him know I saw this video.

[@PragmaticWorks]

Glad you enjoyed (:

[@brunexjundiai]

Wowwww SQL 4 CDS is what I always wanted :) Thanks heaps!

[@PragmaticWorks]

Glad to help!

[@kimp2002]

Great info Brian! Thanks so much for :)

[@PragmaticWorks]

Glad you enjoyed :)

[@AudrieGordon]

Thank you Brian! Awesome tips!

[@PragmaticWorks]

Glad you enjoyed!

[@srikanthgowda6673]

We could use Dataverse REST Builder for building js code also it includes power bi m query , power automate select and filter attributes.

[@oconnoradrian]

This is great, thank you

[@PragmaticWorks]

Glad you liked it!

[@kashiffayyaz6004]

Nice info

[@PragmaticWorks]

Glad you enjoyed!

[@denwo1982]

How do you identify what the primary key foreign keys on an entity

[@PragmaticWorks]

When the column name = the table name, that's your primary key and you can look in the URL when selecting a record to see that GUID.

[@perrya3550]

SQL 4 CDS is huge! I’m getting errors when I try to select/filter on lookup fields tied to the AADUser entity in my queries. What’s weird is I can see the actual aaduser entity in the object explorer and I can query the table directly just fine. Is this a known bug or am I doing something wrong?

[@PragmaticWorks]

Hi Perry. That table in particular is a Linked table using a provider that *might* not be supported for SQL actions. Not 100% but I can replicate your issue too.

[@perrya3550]

@@PragmaticWorks got it. Thanks for the sanity check.

[@crazytubes2249]

@pragmaticWorks Metadata Browser Ext. Kept Loading entities for forever. Any recommendations for a quick fix?

[@varundobhal2203]

Shane Warne 🧐🧐

[@boozer69n]

The XRM Toolbox has that CRM Rest Builder in it. :)

[@PragmaticWorks]

Yes, that one is a great one in XRM Toolbox. That one is kept up to date more too.