How to work with the same app for different datasources (Virtual tables) and Parquet

Like (0) Share

Report

Posted on 18 Sep 2023 14:23:02 by Sven_Datalon

Hello everyone,

In our organization we developed a Dataplatform in Azure Synapse. The configuration of our platform will be done on a serverless SQL pool in Parquet files. Because we wanted a user friendly experience I developed a PowerApp to do the configuration. There are virtual tables of the needed files to configure our platform. All this is working fine for now.

But now the catch. Our customers do get there own Azure Subscription and thereby there own DataPlatform in Azure Synapse.
So we need multiple Apps of our PowerApp app. Every customer needs his own app.
What is the best way to handle multiple apps each with there own data connection? What is the best way to get a new app quickly when we have a new DataPlatform installed.

So in short. We have source with three tables. Our App configures these tables:
1. Sources

2. Entities
3. EntitieColumns

Every customer does get there own PlatForm so for every Customer we need a App consisting of the same tables (names).
What is the best way?

Categories:

Mobile App

All responses (2)

Answers (0)

Sven_Datalon 6 on 18 Sep 2023 at 14:58:47

Like (0)

Report

Re: How to work with the same app for different datasources (Virtual tables) and Parquet

Hi @ANB
Thanks for your reaction.
I know the Export solution option and this worked for us for a long time but we have the next challange.
Before we used a SQL server in our Platform. This SQL server is not longer there and now we use parquet to store our configuration tables. Our app is using virtual dataverse tables to edit these files.
So for every customer we have new tables.
What is the easiest way to export and import the app is this way?
ANB 7,128 Super User 2025 Season 2 on 18 Sep 2023 at 14:45:15

Like (0)

Report
Re: How to work with the same app for different datasources (Virtual tables) and Parquet

Hi @Sven_Datalon ,
Hope you are doing well!
As per your explanation, I understand that you have created one app and now you want to distribute the same app to other customers with their own database. If this is what you are looking then there are options :
Then first of all you need to have one unmanaged solution in your base Power Platform environment. All components should be added to the solution and then follow below things:
Manually export the solution and import in target tenant.
Using ALM export the solution and import in target tenant.
Please check this and this article for more information for manual export and import. For ALM please check this article.
I hope this helps.
Please click Accept as solution 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 giving it Thumbs.
Thanks,
ANB