Unanswered

What is the proper/recommended way to export DATAVERSE tables(both development and production environment) into a data lake?

(0) Share

Report

Posted on by Community Power Pla...

Hi folks,

I am new to export data data from power apps DATAVERSE tables into data lake blob csv using Azure Synapse Link.

I have 2 environments to export dataverse tables which are namely Dev and Prod as names suggest its development and production environment.

So now I want to export data to Azure data lake storage with a single subscription. Here my question is what is the recommended way to export dataverse tables of both dev and prod environment into single subscription azure storage?

could i create 2 separate storage accounts like (storage_dev and storage_prod) to get the dataverse table blob?

or any suggestions?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

KoJaPD 597 on at

Like (0)

Report

possibly you might get what you need by creating a dataflow with the "analytical entities only"?

Was this reply helpful? Yes No

Verified answer

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Hello, @Anonymous , you can create two dedicated SQL server less pools for each Environment. Then Copy the exported Dataverse data to dedicated SQL pool, here is how you do that https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-dedicated

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com