web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : lxm+Fm2840X3mDRWb/c8t6
Power Apps - Microsoft Dataverse
Answered

Microsoft Dataverse vs Azure Cosmos DB

Like (1) ShareShare
ReportReport
Posted on 6 Dec 2021 23:08:42 by 7

Hi folks,

 

Hopefully this is a simple question with an easy answer that I totally missed from all the reading I have been doing recently πŸ™‚

 

I have been slowly immersing myself in all the offerings from Microsoft, in particular on the data side. I see Microsoft has a number of services (many with overlap it seems) so its got my head spinning a bit.

 

I was just learning all about Azure Cosmos DB, and as far as I understand it Cosmos DB is described as a "multi model database system". It can handle a number of integrations with MongoDB, MariaDB etc etc. Cosmos DB is advertised as being used by many of Microsofts applications etc etc  - Ok so this sorta makes sense

 

Then comes the Dataverse and my confusion.

 

Dataverse from what I gather seems to be built on Azure SQL Database? And is mainly for the "Power Platform" suite of applications? I read in some places that the Dataverse isnt part of "Azure" per say, and its more then just a DBMS as it also has a number of API's?

 

So I guess my question is - Whats the difference between the Dataverse and Azure CosmosDB?

 

In my very simple mind, it just sounds like both are database systems - Am I missing something?

 

Thanks in advance

Categories:
  • rodneyc8063 Profile Picture
    7 on 13 Dec 2021 at 17:01:54
    Re: Microsoft Dataverse vs Azure Cosmos DB

    Many thanks for the detailed links! @dpoggemann 

     

    This clarifies a lot!

  • Verified answer
    Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 07 Dec 2021 at 01:46:52
    Re: Microsoft Dataverse vs Azure Cosmos DB

    Hi @rodneyc8063 ,

     

    I answered a question on Dataverse vs. SQL in the following response (https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Dataverse-Vs-SQL-Azure/m-p/1238904 )

    and @EricRegnier wrote a great blog article here:  https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Dataverse-is-not-a-database/ba-p/756215 

     

    Dataverse is utilized behind all model-based Power Apps and Dynamics 365 Customer Engagement applications and can be used in Power Apps Canvas Apps and through APIs as you discussed.

     

    I have not worked a lot with Azure Cosmos DB but I do know it is a powerful database engine in Azure that is schema-agnostic and supports, as you mentioned, MongoDB, Cassandra and other data formats.  It is also geographically dispersed for excellent performance no matter where you are in the world with the data replicated locally and can handle very large volumes of data.  I would normally think of using Cosmos DB in No-SQL type of situations vs. standard relational data that I would store in Dataverse. 

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics

Loading complete