Power Apps – comparing the speed of writing to Excel, Sharepoint and Dataverse

Author: Martin Bradáč

Most of Power Apps is connected to database. But which kind of database to use?

There are big differences in performance, which is manifested mainly in writing a large amount of data.

This test compares Excel, Dataverse, SharePoint, SQL in Azure and On Premise SQL. 

All data sources have a table with two columns. We write the contents of the collection with 1000 rows into it. For writing, the standard ForAll – Patch construction is used.

Results are calculated as an average of multiple runnings.

The winner and loser is no surprise.

Dataverse was able to perform 1 000 writings in 139 seconds. Excel finished in 1 294 seconds and, by the way, it ended with an error on the number of API calls.

Results: