Virtual Tables with Nathan Helgren

XrmToolCast

Content provided by Daryl LaBar and Scott Durow. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Daryl LaBar and Scott Durow or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://staging.podcastplayer.com/legal.

2+ y ago 47:15

MP3•Episode home

In this episode, Daryl and Scott talk to a Senior Program Manager at Microsoft, Nathan Helgren, about the Virtual Tables.

Some of the highlights:

Nathan's 25 years at MS
What are Virtual Tables (VT)?
Difference between a Connector and a VT
Create virtual tables using the virtual connector provider
Virtual Dad Jokes abound
Virtualize all the things?
Building Power Apps using 100% virtual tables
What are the VT Limits?
- No Audit functionality
- No Rollup or Joins between VT
How VT security works
GUID column is still a hard requirement for VT
Query through TDS endpoint from SQL VT
Benefits of pulling through data in real-time in VT
Making more data sources available for the virtual connector provider
Reasons to re-visit VT again for those who have used it long ago

Nathan's Info and other links:

LinkedIn: https://www.linkedin.com/in/nhelgren
Online documents:
- Create virtual tables using connectors https://learn.microsoft.com/power-apps/maker/data-platform/create-virtual-tables-using-connectors
- Known limitations and troubleshooting with virtual tables https://learn.microsoft.com/power-apps/maker/data-platform/limits-tshoot-virtual-tables
- Setting up relationships with virtual tables with Power Apps https://learn.microsoft.com/power-apps/maker/data-platform/setup-virtual-table-relationships
Videos:
- Virtual tables overview: https://youtu.be/weyEDIKhi18
- Create virtual tables: https://youtu.be/ttw4bF1mT3g
- Integrate virtual tables with Dataverse: https://youtu.be/gjum546ycpg

Got questions? Have your own tool you’d like to share? Have a suggestion for a future episode? Contact Daryl and Scott at [email protected]. Follow us on LinkedIn and @XrmToolCast for updates on future episodes.

Do you want to see us too? Subscribe to our YouTube channel to view the last episodes. Don't forget to rate and leave a review for this show at Podchaser.

Your hosts: Daryl LaBar: https://www.linkedin.com/in/daryllabar | @ddlabar Scott Durow: https://www.linkedin.com/in/scottdurow | @ScottDurow

Editor: Linn Zaw Win: https://www.linkedin.com/in/linnzawwin | @LinnZawWin

Music: https://www.purple-planet.com

119 episodes

#Tech #Daryl LaBar #Dynamics365 #Xrmtoolbox #Powerplatform #Tools #Xrm #Scott Durow