Use Dataverse virtual tables in Power Pages sites

A common question I have gotten over the years is if it is possible to build a Power Pages that can surface and interact with data that is stored in a different database than Microsoft Dataverse, such as Azure SQL or other databases.

Using a different database for Power Pages was not only difficult, but downright impossible in the past. Remember (and repeat) Power Pages runs on Dataverse! My colleague at Microsoft, Skylar Shonblom wrote an excellent post There is no Power Pages without Dataverse that explains the importance of learning how to use Dataverse, its features and how it powers Power Pages.

Thankfully, there is now a way to easily link up your tables in Azure SQL, SharePoint, and eventually other data sources to your Power Pages site using virtual tables.

The Microsoft documentation does a good job at explaining how to configure and setup the virtual tables provider and surface the information on a page.

Here is a video where I will walk through the process of setting up and configuring an Azure SQL database table as a virtual table in Dataverse and surfacing it as a list on a webpage, as well as linking it to the Account table and setting up table permissions to protect the data using Power Pages security.

I hope you found this video useful and hoping this feature unblocks you from integrating your Azure SQL or SharePoint list data to your Power Pages sites!

Summary

Virtual tables are a powerful feature of the Power Platform, and being available in Power Pages provides another solution in building powerful business websites and applications.

Will I see you in Dublin?

The European Power Platform Conference is coming to Dublin on June 20-22nd. There are a LOT of great sessions, if you haven’t registered, use the discount code BOOST for 10% off!

Power Pages workshop at Nordic Summit!

In September, as part of the Nordic Summit, I will be delivering a full day workshop on building Power Pages sites! This workshop will start at the basics but will dive into more advanced techniques that you will run into when implementing Power Pages projects. Register today, spots are limited!

Power Platform BOOST podcast

Have you subscribed to the Power Platform BOOST podcast yet? Why not? Every two weeks, Ulrikke Akerbæk and I tell you what’s new (and maybe rant a bit) in the Power Platform community. Listen, like, subscribe!

Nick Doelman is a Senior Content Developer at Microsoft, a Microsoft Certified Trainer, a former Most Valuable Professional (2017-2021), one of the cohosts of the Power Platform BOOST podcast, a community presenter and also competes in international Powerlifting competitions, including the upcoming World Bench Press Championships in South Africa. Follow Nick on twitter at @ReadyXRM