Virtual Tables With Nathan Helgren XrmToolCast podcast

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

1
The Bill Simmons Podcast

The Ringer

176k

Unsubscribe

9h ago9h ago

Unsubscribe

Weekly+

HBO and The Ringer's Bill Simmons hosts the most downloaded sports podcast of all time, with a rotating crew of celebrities, athletes, and media staples, as well as mainstays like Cousin Sal, Joe House, and a slew of other friends and family members who always happen to be suspiciously available.

1
PTI

ESPN, Tony Kornheiser, Michael Wilbon

147k

200

Unsubscribe

2d ago2d ago

Unsubscribe

Daily

Tony Kornheiser and Michael Wilbon face off in the nation's capital on the day's hottest topics.

1
First Take

ESPN, Stephen A. Smith, Molly Qerim Rose

12k

200

Unsubscribe

18h ago18h ago

Unsubscribe

Daily

First Take is always a heated discussion as Stephen A. Smith and guests debate about the day's top stories.

1
Marketplace

Marketplace

436k

Unsubscribe

11h ago11h ago

Unsubscribe

Daily

Every weekday, host Kai Ryssdal helps you make sense of the day's business and economic news — no econ degree or finance background required. "Marketplace" takes you beyond the numbers, bringing you context. Our team of reporters all over the world speak with CEOs, policymakers and regular people just trying to get by.

1
Comedy of the Week

BBC Radio 4

276k

Unsubscribe

5d ago5d ago

Unsubscribe

Weekly

Brighten your week with the latest BBC Radio 4 comedy.

1
The Bugle

The Bugle

228k

662

Unsubscribe

18h ago18h ago

Unsubscribe

Weekly

It's the trans-global satiricast that leaves no hot potato unbuttered. Andy Zaltzman breaks down the news with comedians from across the world including Alice Fraser, Hari Kondabolu, Chris Addison, John Oliver, Nish Kumar, Tiff Stevenson and Helen Zaltzman. Go to TheBuglePodcast.com to become a premium subscriber and get exclusive shows. Follow us on YouTube. Hosted on Acast. See acast.com/privacy for more information.

1
How Did This Get Made?

Earwolf and Paul Scheer, June Diane Raphael, Jason Mantzoukas

432k

277

Unsubscribe

9h ago9h ago

Unsubscribe

Weekly+

The award-winning comedy podcast that celebrates bad movies. Comedians and actors Paul Scheer (The League), June Diane Raphael (Grace and Frankie), and Jason Mantzoukas (Big Mouth) break down the very best of the worst films ever made—we’re talkin’ blockbuster flops, cheesy 80s action movies, Lifetime thrillers, obscure cult classics, and if we’re honest… most Nic Cage and Jason Statham movies. Plus, sometimes they’re even joined by hilarious guests like Seth Rogen, Conan O’Brien, Amy Schume ...

1
Doug Loves Movies

Misfit Toys

338k

Unsubscribe

5d ago5d ago

Unsubscribe

Weekly

Comedian Doug Benson (Super High Me, Last Comic Standing) invites his friends to sit down and discuss his first love: movies!

1
Planet Money

NPR

289k

355

Unsubscribe

19h ago19h ago

Unsubscribe

Weekly+

Wanna see a trick? Give us any topic and we can tie it back to the economy. At Planet Money, we explore the forces that shape our lives and bring you along for the ride. Don't just understand the economy – understand the world. Wanna go deeper? Subscribe to Planet Money+ and get sponsor-free episodes of Planet Money, The Indicator, and Planet Money Summer School. Plus access to bonus content. It's a new way to support the show you love. Learn more at plus.npr.org/planetmoney

1
TED Talks Daily

TED

2477k

Unsubscribe

11h ago11h ago

Unsubscribe

Daily

Want TED Talks on the go? Everyday, this feed brings you our latest talks in audio format. Hear thought-provoking ideas on every subject imaginable – from Artificial Intelligence to Zoology, and everything in between – given by the world's leading thinkers and doers. This collection of talks, given at TED and TEDx conferences around the globe, is also available in video format. Hosted on Acast. See acast.com/privacy for more information.

1
NBC Nightly News with Tom Llamas

NBC News

2133k

600

Unsubscribe

16h ago16h ago

Unsubscribe

Daily

Listen to "NBC Nightly News," providing reports and analysis of the day's most newsworthy national and international events. This audio podcast, updated each evening, brings you the day's show in its entirety. For more from "Nightly News", visit NBCNightlyNews.com.

1
The World This Hour

CBC

1998k

Unsubscribe

39m ago39m ago

Unsubscribe

Daily+

Catch up on the day's most important news from Canada and around the world in 5 minutes. Updated every hour, 24/7.

1
Daily Boost Motivation and Coaching

Scott Smith - Motivation and Coaching

612k

Unsubscribe

4h ago4h ago

Unsubscribe

Daily

The Daily Boost with Scott Smith Successful but still searching? Get the daily motivation you need to face your passion every day. With over 100 million downloads since 2006, The Daily Boost delivers practical motivation for driven professionals and entrepreneurs who refuse to settle for "good enough." Host Scott Smith cuts through the noise with bite-sized episodes that get straight to what matters—helping you do what you love and make a great living while doing it. Based on the proven Face ...

1
Radiolab

WNYC Studios

630k

150

Unsubscribe

2h ago2h ago

Unsubscribe

Weekly

Radiolab is on a curiosity bender. We ask deep questions and use investigative journalism to get the answers. A given episode might whirl you through science, legal history, and into the home of someone halfway across the world. The show is known for innovative sound design, smashing information into music. It is hosted by Lulu Miller and Latif Nasser.

1
Science Friday

Science Friday and WNYC Studios

354k

150

Unsubscribe

5h ago5h ago

Unsubscribe

Daily

Covering the outer reaches of space to the tiniest microbes in our bodies, Science Friday is the source for entertaining and educational stories about science, technology, and other cool stuff.

1
This American Life

This American Life

670k

Unsubscribe

6d ago6d ago

Unsubscribe

Monthly

Each week we choose a theme. Then anything can happen. This American Life is true stories that unfold like little movies for radio. Personal stories with funny moments, big feelings, and surprising plot twists. Newsy stories that try to capture what it’s like to be alive right now. It’s the most popular weekly podcast in the world, and winner of the first ever Pulitzer Prize for a radio show or podcast. Hosted by Ira Glass and produced in collaboration with WBEZ Chicago.

1
Criminal

Vox Media Podcast Network

381k

341

Unsubscribe

1d ago1d ago

Unsubscribe

Weekly

Criminal is the first of its kind. A show about people who’ve done wrong, been wronged, or gotten caught somewhere in the middle. Hosted by Phoebe Judge. Named a Best Podcast of 2023 by the New York Times. Part of the Vox Media Podcast Network.

1
Sword and Scale

Sword and Scale

85k

Unsubscribe

7d ago1w ago

Unsubscribe

Monthly+

Sword and Scale is a weekly true crime podcast covering the dark underworld of crime and the criminal justice system’s response to it. The first episode launched January 1st, 2014 and feature stories of murder, abduction, rape, and even more bizarre forms of crime. It’s the purest form of true-crime where the raw uncensored audio tells the story. Everything from 911 calls to court testimony, interviews with victims and sometimes with perpetrators give listeners a 360 degree look at the seedy ...

1
In The Dark

The New Yorker

82k

Unsubscribe

5M ago19w ago

Unsubscribe

Monthly

In the Dark, hosted by Madeleine Baran, is an award-winning investigative-journalism podcast that started in 2016. Its first season looked at the mysterious abduction of Jacob Wetterling in rural Minnesota and the lack of accountability that sheriffs face when they fail to solve cases. Season 2 examined the case of Curtis Flowers, who was tried six times for the same crime. In 2020, In the Dark released a special report on the coronavirus pandemic in the Mississippi Delta. In 2023, In the Da ...

Virtual Tables with Nathan Helgren

Similar to XrmToolCast

Download the best offline podcast player

Top Podcasts