Announcements
My application is currently sitting on a SQL Database, and it's very, very slow, and the usage is extremely inconvenient. If I transfer the data to Dataverse, will that help?
i have approximately 8000 rows in the database
You can transfer using SDK, DataFlow or using Virtual tables to show the information direct into Dataverse.
Data flow -> An overview of dataflows across Microsoft Power Platform and Dynamics 365 products - Power Query | Microsoft Learn
If your data is very simple, you can use excel import to import the data.
Import or export data from Microsoft Dataverse - Power Apps | Microsoft Learn
If my answer helped you, please give me a thumbs up (👍). If solve your question please mark as solution ✔️. This is help the community.
You have a relatively low number of rows, SQL should handle that no problem.
If you have performance problems, you have several things to check.
no easy answer but I assume if you use Dataverse it will be on the same environment where the app is hosted. That can reduce latency and performance questions between the app and the database. But that still leaves the connection between your computer and the app. If that’s where your bottleneck is, moving to Dataverse won’t matter much.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 536
WarrenBelz 426 Most Valuable Professional
Haque 305