I'm currently working with a dashboard. I got the data from Dynamic connector (Dataverse) from a default environment from my company. However, when my account ceases to exist, I need that dashboard to keep working.
The only available way I've looked up was to create a Dataflow in Power Apps, to migrate data from the default environment of a member of the team to a production one.
Now I face a similar problem I had when working with the refresh of the semantic model of Power BI since I need all the data to be on real time. My only option was to create a Flow with Automate to refresh via API with a button the semantic model.
But now that I face a similar situation here I wonder if there's a better way at handling this options:
Considerations:
1. Migration from one environment to another is mandatory
2. Refresh is necessary in real time
Thanks for any guidance you may have!