Nathan Helgren's guest appearances

Nathan Helgren

Microsoft Business Applications Podcast

XrmToolCast

OwlTail

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 Music: https://www.purple-planet.com

In this episode, Daryl and Scott talk to a Senior Program Manager at Microsoft, Nathan Helgren, about the Virtual Tables. Some of the highlights: <ul> <li>Nathan's 25 years at MS</li> <li>What are Virtual Tables (VT)?</li> <li>Difference between a Connector and a VT</li> <li>Create virtual tables using the virtual connector provider</li> <li>Virtual Dad Jokes abound</li> <li>Virtualize all the things?</li> <li>Building Power Apps using 100% virtual tables</li> <li>What are the VT Limits?  <ul> <li>No Audit functionality</li> <li>No Rollup or Joins between VT</li> </ul> </li> <li>How VT security works</li> <li>GUID column is still a hard requirement for VT</li> <li>Query through TDS endpoint from SQL VT</li> <li>Benefits of pulling through data in real-time in VT</li> <li>Making more data sources available for the virtual connector provider</li> <li>Reasons to re-visit VT again for those who have used it long ago</li> </ul> Nathan's Info and other links: <ul> <li>LinkedIn: <a href="https://www.linkedin.com/in/nhelgren" rel="noopener nofollow" target="_blank">https://www.linkedin.com/in/nhelgren</a></li> <li>Online documents: <ul> <li>Create virtual tables using connectors <a href="https://learn.microsoft.com/power-apps/maker/data-platform/create-virtual-tables-using-connectors" rel="nofollow" target="_blank"> https://learn.microsoft.com/power-apps/maker/data-platform/create-virtual-tables-using-connectors</a></li> <li>Known limitations and troubleshooting with virtual tables <a href="https://learn.microsoft.com/power-apps/maker/data-platform/limits-tshoot-virtual-tables" rel="nofollow" target="_blank"> https://learn.microsoft.com/power-apps/maker/data-platform/limits-tshoot-virtual-tables</a></li> <li>Setting up relationships with virtual tables with Power Apps <a href="https://learn.microsoft.com/power-apps/maker/data-platform/setup-virtual-table-relationships" rel="nofollow" target="_blank"> https://learn.microsoft.com/power-apps/maker/data-platform/setup-virtual-table-relationships</a></li> </ul> </li> <li>Videos: <ul> <li>Virtual tables overview: <a href="https://youtu.be/weyEDIKhi18" rel="nofollow" target="_blank">https://youtu.be/weyEDIKhi18</a></li> <li>Create virtual tables: <a href="https://youtu.be/ttw4bF1mT3g" rel="nofollow" target="_blank">https://youtu.be/ttw4bF1mT3g</a></li> <li>Integrate virtual tables with Dataverse: <a href="https://youtu.be/gjum546ycpg" rel="nofollow" target="_blank">https://youtu.be/gjum546ycpg</a></li> </ul> </li> </ul> Got questions? Have your own tool you’d like to share? Have a suggestion for a future episode? Contact Daryl and Scott at <a href="mailto:cast@xrmtoolbox.com" rel="noopener">cast@xrmtoolbox.com</a>. Follow us on <a href="https://www.linkedin.com/showcase/crmaudio-xrmtoolcast" rel="noopener nofollow" target="_blank">LinkedIn</a> and <a href="https://twitter.com/XrmToolCast" rel="noopener nofollow" target="_blank">@XrmToolCast</a> for updates on future episodes. Do you want to see us too? Subscribe to our <a href="https://www.youtube.com/c/XrmToolCast" rel="noopener nofollow" target="_blank">YouTube channel</a> to view the last episodes. Don't forget to rate and leave a review for this show at <a href="https://www.podchaser.com/podcasts/xrmtoolcast-818506" rel="noopener nofollow" target="_blank">Podchaser</a>. Your hosts: Daryl LaBar: <a href="https://www.linkedin.com/in/daryllabar/" rel="nofollow" target="_blank">https://www.linkedin.com/in/daryllabar</a> | <a href="https://twitter.com/ddlabar" rel="nofollow" target="_blank">@ddlabar</a> Scott Durow: <a href="https://www.linkedin.com/in/scottdurow/" rel="nofollow" target="_blank">https://www.linkedin.com/in/scottdurow</a> | <a href="https://twitter.com/ScottDurow" rel="nofollow" target="_blank">@ScottDurow</a> Editor: Linn Zaw Win: <a href="https://www.linkedin.com/in/linnzawwin/" rel="nofollow" target="_blank">https://www.linkedin.com/in/linnzawwin</a>  | <a href="https://twitter.com/LinnZawWin" rel="nofollow" target="_blank">@LinnZawWin</a> Music: <a href="https://www.purple-planet.com" rel="nofollow" target="_blank">https://www.purple-planet.com</a>

Virtual Tables with Nathan Helgren

FULL SHOW NOTES https://podcast.nz365guy.com/390 A brief introduction about Nathan Helgren’s life and what he does when he’s not working with MicrosoftUnpacking Nathan’s career journey to where he is right now at MicrosoftNathan shares how he got involved with Microsoft Visio AppsNathan talks about Microsoft AccessWhat was Microsoft's motivation that made them think they need an easy migration path from access to Dataverse? Find out more about having a license cost for the connector and if it is part of the connector suite? Have you got any use cases of particular industries or organizations that can solve some problems for their customers?An introduction to MigrationDiscussion about an individual or organization having a database in access that can migrate it to DataverseRESOURCES MENTIONEDMicrosoft Azure - https://www.youtube.com/c/MicrosoftAzure AgileXRM AgileXRm - The integrated BPM for Microsoft Power PlatformSupport the showIf you want to get in touch with me, you can message me here on Linkedin.Thanks for listening 🚀 - Mark Smith

FULL SHOW NOTES <a href="https://podcast.nz365guy.com/390" rel="nofollow" target="_blank">https://podcast.nz365guy.com/390</a> <ul><li>A brief introduction about Nathan Helgren’s life and what he does when he’s not working with Microsoft</li><li>Unpacking Nathan’s career journey to where he is right now at Microsoft</li><li>Nathan shares how he got involved with Microsoft Visio Apps</li><li>Nathan talks about Microsoft Access</li><li>What was Microsoft's motivation that made them think they need an easy migration path from access to Dataverse? </li><li>Find out more about having a license cost for the connector and if it is part of the connector suite? </li><li>Have you got any use cases of particular industries or organizations that can solve some problems for their customers?</li><li>An introduction to Migration</li><li>Discussion about an individual or organization having a database in access that can migrate it to Dataverse</li></ul> RESOURCES MENTIONED Microsoft Azure - <a href="https://www.youtube.com/c/MicrosoftAzure" rel="nofollow" target="_blank">https://www.youtube.com/c/MicrosoftAzure</a> <a href="https://www.agilexrm.com" rel="nofollow" target="_blank">AgileXRM</a> AgileXRm - The integrated BPM for Microsoft Power Platform<a href="https://www.buymeacoffee.com/nz365guy" rel="payment nofollow" target="_blank">Support the show</a>If you want to get in touch with me, you can message me here on <a href="https://www.linkedin.com/in/nz365guy" rel="nofollow" target="_blank">Linkedin</a>. Thanks for listening 🚀 - Mark Smith