Carlos Mateus

(0) Share

Report

Posted on by CU12060204-0

Actualmente me encuentro desarrollando un ERP para una empresa avícola utilizando Microsoft Power Platform. La solución incluye módulos de inventarios, producción, trazabilidad, gestión de lotes, automatizaciones con Power Automate y análisis de información con Power BI.

Inicialmente, la base de datos fue construida sobre Microsoft Lists debido a su facilidad de implementación y bajo costo. Sin embargo, a medida que el proyecto ha crecido y el volumen de información ha aumentado, hemos comenzado a experimentar problemas de rendimiento, limitaciones de delegación en Power Apps y mayores tiempos de respuesta en consultas y procesos transaccionales.

Teniendo en cuenta que se espera un crecimiento continuo de los datos y de los usuarios que interactúan con la plataforma, surge la siguiente inquietud:

¿Consideran que vale la pena realizar una migración a Dataverse para garantizar escalabilidad, rendimiento y mantenibilidad a largo plazo? ¿O recomendarían evaluar otras alternativas como Azure SQL, SQL Server u otra fuente de datos que ofrezca una mejor relación entre costo, rendimiento y facilidad de integración con Power Platform?

Me gustaría conocer experiencias reales de proyectos que hayan iniciado en Microsoft Lists y posteriormente hayan migrado a una arquitectura más robusta.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!
For a poultry ERP system that includes inventory, production, batch tracking, and traceability, Dataverse is the most suitable strategic platform for long-term

scalability, maintainability, and Power Platform integration.

If budget permits, I would recommend:

Designing a migration plan from Microsoft Lists to Dataverse.

Reviewing your data model and relationships before migration.

Reserving Azure SQL for future analytical or high-volume data requirements rather than as the primary transactional system.

This approach provides the best balance of performance, scalability, security, maintainability, and alignment with Microsoft's long-term Power Platform roadmap.

Was this reply helpful? Yes No
Suggested answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CU12060204-0 ,

Dataverse is a relational database based on Microsoft Azure SQL server architecture with additional layers for security, metadata, and app integration and is actually the optimum data source for Power Apps, being specifically designed for it.

Lists (SharePoint) is a robust platform for smaller data sets (with some Delegation limitations as you have mentioned) with a lower cost. If you have already migrated to Dataverse, I would recommend that you remain with it.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CU12060204-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No