Power Platform Community Forum Thread Details

Hello,

To answer the question of whether we start a new application using Dataverse or SQL as data sources, I am looking into Dataverse at this time. My team has solid experience with SQL and our databases are in Azure SQL as well as we have some data that will need to be collected from Excel files. I have noticed that transferring data from SQL to Dataverse, and from Excel to Dataverse won't be a straightforward setup (Especially the process of recreating the lookup columns and the relationships). I do lean toward using Azure SQL as our Datasourcee but I would love to hear from experts in this forum who might have to go through such a decision.

Thank you

Categories:

Microsoft Dataverse with Power Apps

Hey @AhmedSalih

Welcome to the forum. Assuming you are creating model-driven/ portal then the best fit would be Dataverse. The inbuilt architecture is closely tied up with dataverse. Almost all functionalities are possible including file attachments. This will eventually save you some time and all kinds of automation possibilities via power automate.

Having said that, you are not just limited to dataverse. There are few more options for you.

1. You can use power apps data flows and Azure Synapse link for dataverse

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-and-use-dataflows

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/export-to-data-lake

2. Option 2: You can also try virtual tables which is cool where you can link your Azure SQL.

https://docs.microsoft.com/en-us/powerapps/developer/data-platform/virtual-entities/get-started-ve

Hope it shed some light on you to think about the possibilities.

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.