Forum Discussion
Refreshing a dataset through a Power Automate flow from a PowerApp without providing excess access
Two things to consider
- is there a gateway involved in your scenarios? If not, could it be (ie abuse it to refresh cloud data sources that wouldn't technically need a gateway)
- have you considered using Direct Query instead of Import Mode? Or the new hybrid partition option ?
In either case the lack of native data write-back capabilities in Power BI will continue to make this an awkward user experience. Please consider voting for the ideas that have been raised about this.
Thanks for the response!
Our main problem is that our full dataset is very large (apx. 3bn rows), so querying the data directly through PowerBI makes this proces extremely slow. It is admittedly a bit of a "hacked" solution, and having the end user press an extra button is not the end of the world, but i do find it very weird that the level of workspace access that is required to refresh a dataset, is directly tied to where the flow was triggered from.