Virtual Tables with Nathan Helgren
Episode description
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 cast@xrmtoolbox.com. 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