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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Transferring Data to D...
Power Apps
Unanswered

Transferring Data to Dataverse

(1) ShareShare
ReportReport
Posted on by 140

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 

I have the same question (0)
  • MichaelFP Profile Picture
    1,943 Moderator on at

    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.

     

  • ivan_apps Profile Picture
    2,189 Moderator on at

    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.

     

    • Is your SQL server robust enough to handle your queries? If you created a 1 core sql server with 5MB growing storage from 0, it’s not gonna cut it for ANY application. Check performance monitors to see how pegged it is.
    • what kind of queries is you application running against SQL? Are you using many column level secured fields? Security calculations can be expensive if you implemented extensive column-level security.
    • the big one: what does your network path look like between the app and SQL. Is it an on-prem SQL box or cloud based? What is the latency in the network? Are you going across geographic boundaries (SQL in Europe, app environment in US West). Finally, what’s your computer’s internet latency to the power platform infrastructure? Are you going through several firewalls? Corporate network? Throttling can greatly reduce your experience.

    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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 536

#2
WarrenBelz Profile Picture

WarrenBelz 426 Most Valuable Professional

#3
Haque Profile Picture

Haque 305

Last 30 days Overall leaderboard