Forum Discussion

TKRA's avatar
TKRA
Regular Visitor
4 years ago

Refreshing a dataset through a Power Automate flow from a PowerApp without providing excess access

Hi,   I am currently in the process of developing a power BI report which should be accessible to a wide array of people, and I would therefore like to avoid giving too much access.   The report ...
Data Protection
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

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.

  • TKRA's avatar
    TKRA
    Regular Visitor
    4 years ago

    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.