Safely hyperscale low-code apps with ease using Microsoft Dataverse (2023)

Data is synonymous with work in the modern day. For developers it’s the foundation of any app, website, bot, or more that they build. For organizations, data is critical to make decisions that reflect the needs of their clients and grow their business. To build the most efficient and impactful technical solutions and make the soundest business decisions, developers and knowledge workers alike require clean data.

Low-code is a key component in saving developers time and capital to help them build business-critical applications that drive efficiency for themselves and their organization. For organizations to maximize low-code, having clean, secure, and accurate data is imperative.

At Microsoft Build 2023, Microsoft Dataverse has further enabled organizations to rapidly build data-driven applications and business processes that are interconnected across Microsoft Cloud in a secure and compliant manner.Try Microsoft Dataverse today with the Power Platform Developer Plan.

Safely hyperscale low-code apps with ease using Microsoft Dataverse (1)

Unlock a new age of AI-enhanced productivity with enterprise data

Dataverse is making it easier than ever for professional and citizen developers to build apps on their enterprise data, generating increased efficiency. Dataverse is continuing to improve developer time to market with the introduction of Excel to app, powered by Copilot in Microsoft Power Apps and the introduction of custom plug-ins in Dataverse built using Microsoft Power Fx.

Excel to app is just that. Excel to app enables citizen developers to build an app on their Excel data by dragging and dropping or copying a link to their Excel spreadsheet into Dataverse. From there, Copilot in Power Apps assists in analyzing data to provide suggested table structures, column names, and data types in a Dataverse table. Excel to appthen generates an app on top of data, which developers can immediately start to customize. Get started today with Excel to app in preview.

Dataverse-enabled features like Excel to app are helping Microsoft cloud customers—ranging from those who use Microsoft Power Platform to those who use Microsoft 365—organize, store, and use their data for increased efficiency.

Chevron is one of those customers, as they’ve used Microsoft Dataverse to maximize their Microsoft data estate.

“We want to make it easy to do the right thing when it comes to data architecture and reducing data duplication, and Microsoft Dataverse helps make it possible. Not only does it eliminate complexity associated with virtual tables, it helps modernize data that needs a home by liberating and protecting stranded data traditionally stored in Excel files.”—Tavia Prouhet, Product Owner of Low-Code and Automation, Chevron.

Two months ago, we announced Microsoft 365 Copilot, a revolutionary new way of working that uses AI to enable users to get answers and perform tasks using natural language prompts. Available now to early access customers, Copilot combines the power of a large language model, Microsoft productivity and business apps, and your data—your calendar, emails, chats, documents, meetings, and contacts—to do things you’ve never been able to do before, just by telling it what you want. For example, give Copilot a natural language prompt like “Tell my team how we updated the product strategy,” and it generates a status update based on the morning’s meetings, emails, and chat threads.

Safely hyperscale low-code apps with ease using Microsoft Dataverse (2)

We’re excited to announce that now Microsoft 365 Copilot can incorporate your Dynamics 365 and Power Platform data stored in Dataverse, all in an easy-to-use, unified experience. By replacing dozens of steps in multiple apps and constant context switching with simple, natural language prompts, imagine what your teams can accomplish in minutes instead of hours:

  • A sales professional can generate a status update for the top 25 leads based on engagement activity over the past two weeks.
  • A marketer can summarize topics and needs from responses and update an email marketing campaign in real time.
  • A customer service manager can summarize the top trending customer issues from the past week as an email to senior leadership.

Microsoft 365 Copilot automatically inherits the native security and governance framework of Dataverse and applies user security and permissions at runtime.

Safely hyperscale low-code apps with ease using Microsoft Dataverse (3)

Add the power of your line-of-business and independent software vendor (ISV) apps as plug-ins through more than 1,000 Power Platform connectors when Microsoft 365 Copilot becomes generally available. For example, Microsoft 365 Copilot with the Power Platform connector for Jira Software can enable a project manager to request the status of a Jira support ticket and act based on the response, such as route it for additional approval or start a purchase order for new hardware. Integrate your business processes and data more tightly with Microsoft 365 Copilot and the extensibility of Power Platform connectors and Dataverse.

Safely hyperscale low-code apps with ease using Microsoft Dataverse (4)

Extend your low-code apps using Power Fx in Dataverse

To build business critical apps with low-code, integrating extensible components is crucial. Microsoft is making it easier for developers to extend their apps by building custom plug-ins in Dataverse using Power Fx.

Plug-ins in Dataverse are reusable, real-time business logic workflows that allow developers to execute a set of specific commands, called from web services, like the Dataverse connector or a web API.

For example, if a developer wants to automate their organization’s “thank you” emails to customers, the developer can use plug-ins in Dataverse to automate the distribution of “Thank you for your order” emails whenever a new sales order is submitted.

These plug-ins are multifaceted as developers can build plug-ins that can perform Dataverse CRUD operations, access other data tables in their Power Apps environment, generate instant actions that can accept input and output parameters, call other actions, and more.

Brian Hodel’s, Principal Developer, Power Platform, T-Mobile use of plugins in Dataverse is a great example of building enterprise-grade apps with plugins and Power Apps. “Dataverse accelerator allows you to easily develop custom sets of Dataverse plugins in a simple, familiar interface. This is a huge step forward in optimizing performance in Canvas Apps as you can delegate even more of the processing to Dataverse. It also helps to simplify code and further make use of Fusion Teams as those functions are available in apps and flows just like any other function call in Power Fx.”

Plug-ins in Dataverse are in preview, so get started today.

Safely hyperscale low-code apps with ease using Microsoft Dataverse (5)

Hyperscale your low code applications on Dataverse

To call an application enterprise-grade it must be able to handle thousands of users and should have the ability to scale seamlessly as users and records grow. At Microsoft Build, Dataverse is further enabling enterprise-grade development on Power Platform with the announcement of elastic tables. An elastic table is a data table managed by Dataverse designed to handle large volumes of data in real-time. With elastic tables, developers can import, store, and analyze large volumes of non-relational data without scalability, latency, or performance issues, even automatically scaling to ingest and read tens of millions of rows every hour.

Try elastic tables in preview today to build your enterprise-grade low code applications on Microsoft Dataverse.

Build secure apps faster than ever on Dataverse

The foundation of any enterprise-grade solution is security and Dataverse is enabling even more granular security in Microsoft Power Platform with new IP access management and managed encryption key features.

As such, Microsoft Dataverse is announcing the first phase of Microsoft Sentinel Solution for Power Platform (a premium offering), allowing customers to detect various suspicious activities such as Power Apps execution from unauthorized geos, suspicious data destruction by Power Apps, mass deletion of Power Apps, and phishing attacks made possible through Power Apps. Sign up for the preview here: Limited Public Preview Sign Up Microsoft Sentinel Solution for Power Platform.

As organizations continue to adopt and build a multitude of solutions on Dataverse, it’s increasingly important to restrict access to data to the right users at the right times and in the right places. As such, Dataverse is enabling IP restrictions with Microsoft Azure Active Directory (Azure AD) continuous access evaluation and IP firewall to govern user access in real time.

Azure AD continuous access evaluation automatically blocks a user’s access in near real-time if suspicious activities are detected. Critical events like user account deletion or disablement, or IP location change, are monitored continuously. When an event that requires restriction of user access occurs, enforcements take effect in almost near real time to deny the user access.

Couple these near real-time access IP enforcements with an IP firewall that can restrict user access if the computer IP isn’t a part of a trusted network and threats like insider data exfiltration or token replay attacks can be mitigated for all business processes running atop Dataverse.

In addition to improving granular security access, Dataverse made storing sensitive customer data safer by integrating Microsoft Azure Key Vault customer-managed encryption keys in Dataverse environments.

Mercedes-Benz has found success with customer managed key (CMK) and the security investments in Dataverse overarchingly, as it’s made it easier for them to build more complex solutions on their enterprise-data.

“Preventing other parties from accessing data stored in the cloud has been a key concern for Mercedes-Benz from the beginning. This became even more important as we embraced the “cloud first” paradigm striving to make the most out of cloud capabilities. We deem the risk so severe, that we do not allow confidential data to be stored in the cloud if that risk is not mitigated properly. This made the use of Dataverse and the low-code / no-code capabilities complex using the Power Platform. Microsoft’s new security features help a lot in this regard, CMK being the key aspect but not underestimating the rest like IP based cookie binding and IP Firewall, subnet delegation and others. While the features in itself are changing the game, the support, consulting and help implementing these are a constant boon for our security efforts and just one more reason why we place our trust in Microsoft’s Power Platform.”—Patric Liebelt, Lead Center of Enablement, Microsoft Power Platform, Mercedes-Benz.

As demands for secure enterprise-grade applications continue to mount, low-code becomes increasingly necessary for developers to add to their toolkit to help them produce high quality solutions in a fraction of the time. Microsoft Power Platform is one of the most comprehensive low-code platforms available with a best-in-class data platform designed to support and scale enterprise applications.

Learn more about Microsoft Power Platform

  • Get started with Microsoft Dataverse using the Power Apps developer plan.
  • Watch the Microsoft Power Platform Build 2023 keynote.
  • Watch the Microsoft Power Platform and Dataverse Build 2023 discussion.


What are the limitations with Dataverse? ›

With Dataverse for Teams, there is a limit in storage capacity (1 million rows or 2 GB). If you think you will need to manage more data than this, then you should consider Dataverse. However, you can always start with Dataverse for Teams and then move up to Dataverse if necessary.

Is Dataverse an application platform? ›

Innovate easily with Microsoft Dataverse. Create and run thousands of applications, flows, and intelligent agents with a smart, secure, and scalable low-code data platform. Try it free through a Power Apps trial.

Is Microsoft Dataverse secure? ›

One of the key features of Dataverse is its rich security model that can adapt to many business usage scenarios. This security model is only in play when there is a Dataverse database in the environment.

Is Powerapps low-code or no code? ›

Expand app development across your organization with Microsoft Power Apps—a low-code development platform that enables anyone to create robust business apps for web and mobile.

Why use Dataverse instead of SQL? ›

Dataverse vs SQL database

Why should an organization choose Dataverse rather than SQL? Because Microsoft Dataverse is more than just a database. As opposed to SQL, Dataverse also includes a business application layer. It includes a set of features that are usually found in applications, or systems.

Why use Dataverse instead of SharePoint? ›

Any web part in SharePoint that holds content can be considered a SharePoint List. The key difference of Dataverse is that it is a relational database just like Microsoft SQL. This will allow you to form relationships and lookups to other tables of data.

Is Dataverse SQL or Nosql? ›

Leverage Your Power Platform Solutions Using Microsoft Dataverse
SQL knowledge requiredNo SQL knowledge required
Made for pro developersMade for citizen developers
Managed by IT / DB analystsManaged by IT / super users
Supported model: IaaS / PaaSSupported model: SaaS
4 more rows
Feb 23, 2022

Is Dataverse an ETL tool? ›

Open-source ETL from Microsoft Dataverse. Load your Microsoft Dataverse data into any data warehouses, lakes or databases, in minutes. In the format you need with post-load transformation.

Is Dataverse the same as SQL? ›

The key difference of Dataverse is that it is a relational database just like Microsoft SQL compared with the other options. This will allow you to form relationships and lookups to other tables of data. The downside of this option is that it will require premium licenses which can be quite costly.

Is Dataverse low code? ›

Dataverse is the data platform for all Power Platform products and Dynamics 365 applications, supporting both low-code and pro-code development.

Is Dataverse data encrypted? ›

All environments of Microsoft Dataverse use SQL Server Transparent Data Encryption (TDE) to perform real-time encryption of data when written to disk, also known as encryption at rest.

Is Dataverse better than SharePoint list? ›

I find that SharePoint Lists are good if you data has small set of records (e.g. in the 100s) and one list. Dataverse is better for data growth. Some of the benefits of Dataverse over lists are: Security and Permissions can be managed better for the data.

What are the disadvantages of low-code app development? ›

Poor application performance and resource use is a common complaint about low-code. Low-code application performance is almost always noticeably poorer than software developed in a true programming language.

Is low-code no-code the future? ›

In conclusion, low-code will work well in the future for a variety of simple business apps, but not for advanced, custom apps. Traditional programming is then required.

Is SharePoint low-code? ›

Low code intranet development is possible with SharePoint, with a variety of different options. It can help reduce costs, dramatically reduce the time to market and increase the business value of your intranet.

Can Dataverse replace SQL? ›

Dataverse is a good alternative to SQL for storing transactional, structured data, and then quickly building low-code solutions on top of that data. Dataverse is actually built on top of Azure SQL (and uses other data stores under the hood for other types of data).

Can I use Dataverse as a database? ›

You can create a database and build apps by using Dataverse as a data store. You can either create your own custom tables or use the predefined tables. To create a database, you first need to either create an environment, or be assigned to an existing environment as an Environment Admin.

Is Azure the same as the Dataverse? ›

It is a service on its own. Dataverse stores Table Data in Azure SQL. But it also stores Table data in Azure Storage, Cosmos DB, Azure Data Lake and Cognitive Search – all in an intelligent way without you being in need of making a decision.

Is Dynamics 365 the same as Dataverse? ›

Dynamics 365 applications—such as Dynamics 365 Sales, Dynamics 365 Customer Service, or Dynamics 365 Talent—also use Dataverse to store and secure the data they use.

Is Dataverse free with Office 365? ›

Yes, Microsoft Dataverse does come included with Microsoft 365, however, it has many limitations. The included service allows select Microsoft 365 applications to access Dataverse in order to store application data and use the underlying business logic tier as part of extending application capabilities.

Does Office 365 use Dataverse? ›

Dataverse capabilities with Microsoft 365 licenses. As Dataverse continues to grow, more Microsoft applications like Microsoft Project are using Dataverse. To enable these Microsoft applications, limited Dataverse functionality is added to select Microsoft 365 licenses.

Can Dataverse store unstructured data? ›

Microsoft Dataverse allows the storage of many types of data in customizable tables. Depending on your data needs, it's possible to store structured and unstructured data in one or many environments.

What is the difference between Dataverse and dataset? ›

What is the difference between a Dataverse and a Dataset? A Dataverse is a container for your Datasets. We recommend you first create a Dataverse and then add Datasets to that Dataverse. The Dataverse can be for an individual researcher, for a research group, for an entire department, for a journal, etc.

Is Dataverse a cloud database? ›

Enter Microsoft Dataverse: a powerful cloud-based database platform that allows companies to securely store and manage their data.

Is Dataverse built on SQL? ›

Dataverse data is stored in a combination of Azure SQL and Azure Blob storage. Azure SQL Database is a relational database service built for the cloud.

What is the old name of MS Dataverse? ›

Common Data Service (CDS) — the data storage system that intensifies Dynamics 365 and Power Platform — has changed its name to Dataverse, part of a bigger rebrand at Microsoft. Dataverse does the same thing as CDS — but with a different name.

Is Dataverse a data lake? ›

Azure Synapse Link for Dataverse was formerly known as Export to data lake. The service was renamed effective May 2021 and will continue to export data to Azure Data Lake as well as Azure Synapse Analytics.

What type of database is Microsoft Dataverse? ›

Dataverse includes a float data type. However, it has lower limits than Access a min/max of +/- 100,000,000,000 or +/- 99,999,999,999.99999. A maximum of five decimal places is supported.

How much does Microsoft Dataverse cost? ›

Explore Power Apps plans
Subscription plans
Per app plan $5 user/app/monthPer user plan $20 user/month
Use Microsoft Dataverse (formerly Common Data Service)400 MB file capacity62 GB file capacity6
Executive WorkflowsPower Automate use rights (including premium connectors)8
Asynchronous and custom real-time workflows
7 more rows

Is Microsoft Dataverse in Azure? ›

Microsoft Dataverse supports integration with Azure. Developers can register plug-ins with Dataverse that can pass runtime message data, known as the execution context, to one or more Azure solutions in the cloud.

What is the maximum database size for Dataverse? ›

The default environment has the following included storage capacity: 3GB Dataverse database capacity, 3GB Dataverse file capacity, and 1GB Dataverse log capacity.

Is Dataverse free with Powerapps? ›

Microsoft Dataverse – a premium edition that requires a Power Apps premium subscription. Allows creating the apps accessible from all interfaces. Microsoft Dataverse for Teams – free edition of Dataverse with some limitations.

Can Microsoft Dataverse be used even without the Internet? ›

Note, an internet connection is required to sync data between your mobile device and Microsoft Dataverse. To get started with mobile offline, an app maker needs to enable and define the tables that are available for offline by using the modern app designer.

How do you secure data in Dataverse? ›

Protect. We recommend the following preventative steps: Utilize Azure AD authentication to confirm identities of those logging into the system. Leverage conditional access authentication based on IP address, location, device, or other properties of the user's authentication context.

Can Dataverse be used as a datawarehouse? ›

MS Dataverse works as a data warehouse. The system is made up of what Microsoft calls tables (formerly entities). These tables can be compared with the tables of an SQL database and Excel tables.

Is Microsoft Dataverse Hipaa compliant? ›

Yes, Microsoft's Azure and power platform tools are "compliant insofar as they can be" with HIPAA & HITECH.

Does Dataverse cost extra? ›

Power Apps Per User Plan

Enabled rights to use the Dataverse CDS as a data source with larger capacity. Cost is $20/user/month.

When to choose Dataverse? ›

When to use Dataverse:
  1. Data needs to be frequently Created, Read, Updated and Deleted (CRUD Operations)
  2. Large data volume or will grow to a large data volume.
  3. Large amounts of data need to be ingested or exported.
  4. Requires a normalized data model.
  5. Role-based access.
  6. You require a model-driven app.
Jan 11, 2021

How many apps can use the same table in Dataverse? ›

Yes, you can use the same table on as many apps you need. Each app need a connection to this table.

Are low-code platforms secure? ›

Handled appropriately, low-code development tools pose no additional security risk over any other platform, system, or development environment.

Why low-code is better than no-code? ›

Basic feature differences between Low-Code and No-Code

A low-code platform is mostly leveraged by IT professionals with coding knowledge to create complex custom applications, while no-code platforms enable business users to create apps without any coding to address their business needs.

Is IT worth learning low-code? ›

Developers typically benefit from low-code tools because it increases the amount of high-value work they can do. This is not only better for the organization, but it's better for developers too.

Will low-code replace software engineers? ›

However, low-code tools will never replace developers, especially those working with C++, Python and Java languages. Though low-code tools could replace handwritten codes, companies and businesses need developers to optimize the software and its applications.

Will no-code replace software engineers? ›

Let's be clear upfront: low-code will not replace high-code developers working in languages like Java, C++, or Python. Citizen developers won't replace senior developers with decades of experience or even junior developers with a year or so on the job.

Will lowcode development replace coding? ›

Low-code will not replace the need for coding or make obsolete the practices built around developing custom software capabilities”.

What is Microsoft Dataverse? ›

“Microsoft Dataverse is the data backbone that enables people to store their data in a scalable and secure environment dynamically. It enables [us] to look at data as a service spun up on-demand to meet ever-changing business needs.”

Is SharePoint going away? ›

The on-premise SharePoint runs on a Client Access License model (Server/CAL), which gives users the legal right to access services within a server. Currently, the SharePoint 2013 support is still up and running, but Microsoft will officially end it with the SharePoint 2013 end-of-life happening in April 2023.

Is Microsoft a low-code platform? ›

Power Apps is Microsoft's low-code development platform that empowers developers, business users, and CRM Administrators to create custom native mobile and web applications by connecting to the cloud or on-premise data source. Power Apps leverage the Common Data Service (CDS).

How is Dataverse different from other databases? ›

The key difference of Dataverse is that it is a relational database just like Microsoft SQL compared with the other options. This will allow you to form relationships and lookups to other tables of data. The downside of this option is that it will require premium licenses which can be quite costly.

What is the limit of dataflow in Dataverse? ›

Users can't add files or attachments to Dataverse while loading the data. There is no guidance on the optimal number of entities in the dataflow. Dataflow has a refresh limit of two hours per entity.

What is the limit for Harvard Dataverse? ›

All researchers from any discipline, both inside and out of the Harvard University community, can deposit files of up to 2.5GB, and store up to 1TB of data on the Harvard Dataverse Repository.

What is the row limit for Dataverse for Teams? ›

With Dataverse for Teams, capacity is measured with relational, image, and file data. The 2-GB capacity provided to a team can typically store up to 1 million rows of data.

How many columns can a Dataverse table have? ›

You get up to 950 columns to be searchable via Dataverse). Now that the table is configured to be searchable using Dataverse search, lets dig into the Quick Find Views within the tables themselves.

How do I increase my Dataverse capacity? ›

Purchase add-on storage capacity
  1. Sign in to the Microsoft 365 admin center. ...
  2. In the left pane, select Billing > Purchase services.
  3. Search for "capacity". ...
  4. Select your products as required: Common Data Service File Capacity, Common Data Service Log Capacity, or Common Data Service Database capacity.
Feb 14, 2022

What are the requirements for Dataverse? ›

System Requirements

For example, as of this writing the test installation at is backed by a single virtual machine with two 2.8 GHz processors, 8 GB of RAM and 50 GB of disk.

Is Harvard Dataverse free? ›

Harvard Dataverse is a free data repository open to all researchers from any discipline, both inside and outside of the Harvard community, where you can share, archive, cite, access, and explore research data.

How much can you upload to Dataverse? ›

The maximum value is 10485760 KB (10 GB). While the API can handle files up to 10 GB in size, Power Apps client controls currently only support files up to 128 MB. Exceeding the 128 MB value when using these controls will result in errors uploading or downloading files.

How many tables are in Dataverse? ›

There is no specified limit on the number of tables for Dataverse.

Does Dataverse for Teams have a 2gb limit? ›

Per-environment limits on Dataverse for Teams environments: Each Dataverse for Teams environment provides 2 GB of combined database and file storage, with a portion of this amount reserved for system use.

Top Articles
Latest Posts
Article information

Author: Margart Wisoky

Last Updated: 08/11/2023

Views: 6235

Rating: 4.8 / 5 (58 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Margart Wisoky

Birthday: 1993-05-13

Address: 2113 Abernathy Knoll, New Tamerafurt, CT 66893-2169

Phone: +25815234346805

Job: Central Developer

Hobby: Machining, Pottery, Rafting, Cosplaying, Jogging, Taekwondo, Scouting

Introduction: My name is Margart Wisoky, I am a gorgeous, shiny, successful, beautiful, adventurous, excited, pleasant person who loves writing and wants to share my knowledge and understanding with you.