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.
If it's any consolation - once you started over and connect to a SQL server table in Direct Query mode you can make this a nearly seemless experience for your users. Push the PowerApps button which writes the user comments to the SQL table and then issues a Powr BI refresh which surprisingly works despite fact that the data source is direct query, and a couple seconds later the user has visual confirmation of the changes they just made.
What we really need is CDC - the ability to write into the dataset that is currently in memory, and at the same time to write back into the data source. It can be done - other BI vendors have shown that.
I think that refresh can only be seen if I turn on auto page refresh - is that correct? I don't see minor changes comeing through from SQL to the report unless I reload my browser page.
Yes, CDC would be nice - or something similar. I'm catching up with a MS rep next week on another matter and maybe I can convince them to have another look at this? Wait and see what comes of that meeting I guess 🙂
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.