Forum Discussion
PowerBIIntegration.Refresh() PowerApp workaround??
There is no workaround, you need to start over.
Thanks mate. I was hoping for a better outcome - not to be.
Seems this should be something that MS could look at fixing though, it's been an idea for 4+ years now. My current 'workaround' is for users to reload their browser to see their new data, ie
1. user clicks company logo, triggers a bookmark that displays the app
2. user makes edits / adds new data and submit form/s
3. user clicks bookmark icon to 'go back to report' / hide app
4. user reloads their browser to see new data
Not ideal but works.
Thanks again.
No, auto page refresh is not required. I was surprised to see that as it wasn't what I had expected. The powerbiintegration.refresh request not only triggers a dataset refresh but also a rerendering of the page the PowerApp visual is on - which results in a new query against the Direct Query source. At least that's my theory.
Ahh, sorry, I just re-read you last post. You were saying that '... once you started over ...', meaning once I rebuilt the app. I was thinking you were seeing this behaviour with an app built in a similar way to the way I built mine. All good - got it now haha
And yes, that's my understanding of PowerBIIntegration.Refresh() - it refreshes the data source and the browser instance. I think those vendors you mention may have used Javascript to mimic the refresh behaviour? I might see if I can work out how they did this - can't be too hard ... surely lol
And yes, that's my understanding of PowerBIIntegration.Refresh() - it refreshes the data source and the browser instanceThat's not exactly what I said. It does not refresh the data source. It triggers a dataset refresh request. There's a (big) difference.