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