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.
![Many to Many Relationships in Power Apps [Dataverse Relationships Part 3]](/img/n.gif)
Jason will be glad to know someone still using Rest Builder! I will let him know I saw this video.
Glad you enjoyed (:
Great info Brian! Thanks so much for :)
Glad you enjoyed :)
Wowwww SQL 4 CDS is what I always wanted :) Thanks heaps!
Glad to help!
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.
This is great, thank you
Glad you liked it!
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?
Nice info
Glad you enjoyed!
Shane Warne 🧐🧐