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?
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.
Jason will be glad to know someone still using Rest Builder! I will let him know I saw this video.
Glad you enjoyed (:
Wowwww SQL 4 CDS is what I always wanted :) Thanks heaps!
Glad to help!
Great info Brian! Thanks so much for :)
Glad you enjoyed :)
Thank you Brian! Awesome tips!
Glad you enjoyed!
We could use Dataverse REST Builder for building js code also it includes power bi m query , power automate select and filter attributes.
The XRM Toolbox has that CRM Rest Builder in it. :)
Yes, that one is a great one in XRM Toolbox. That one is kept up to date more too.
This is great, thank you
Glad you liked it!
Nice info
Glad you enjoyed!
How do you identify what the primary key foreign keys on an entity
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.
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?
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.
@@PragmaticWorks got it. Thanks for the sanity check.
@pragmaticWorks Metadata Browser Ext. Kept Loading entities for forever. Any recommendations for a quick fix?
Shane Warne 🧐🧐