Forum Discussion
DirectQuery + Embed for customers. Any way to automatically refresh report without page navigation?
Every SECOND? Really?
No, Direct Query only refreshes when you ask it to, like navigating to a page or interacting with a visual.
Check out a STREAMING DATASET in Power BI.
A Direct Query does a PULL operation, in that Power BI initiates the data refresh from its end, basically PULLING the data from the source.
In a STREAMING DATASET, the source PUSHES the data to Power BI on its schedule.
"Direct Query only refreshes when you ask it to, like navigating to a page or interacting with a visual."
Yes I've discovered that myself. What I'm asking is whether there's any way to cheat this by building a "refresh" button on the report, and have it navigate to a page and then back again, or interact with a visual without changing it.
Otherwise how will my customers know that to refresh the visuals to display the new live data they have to navigate pages or interact with a visual?
Have you investigated PUSHING data via a STREAMING Dataset?
I honestly believe that it could *probably* be done the way you think, but is that the right tool for the end result? You asked about how to code a specific solution. I'm giving a suggestion based on the END RESULT you desire, not the code you want.
Yes I have investigated pushing data via a streaming dataset. My understanding is it limits the visuals you can use in a way that makes it not suitable for my use case.
As you are giving me suggestions based on my desired end result, I can expand on that a little. My use case is to display scores of an Adventure Golf tournament as the tournament is played. Here is an example of what my report will look like (this used Import Mode, I only use the DirectQuery mode as the tournament is being played)