Forum Discussion
DirectQuery + Embed for customers. Any way to automatically refresh report without page navigation?
I have a report that uses a DirectQuery data source.
I have published this online on my company's website using the Embed for Customers method with an A1 SKU premium capacity. This will allow my customers to view data analytics on a live data stream.
I have set the pages on the report to refresh every second.
I know this works, I can view the reports as a customer, and when new data arrives on the data stream the visuals on the report do update BUT only after I either do some page navigation, interact with a filter, or interact with a visual in some other way.
Is this expected behaviour? It is not very intuative my customers who expect to watch the report and see the visuals updating with any of these kind of interactions being required.
Is there any way to make this more intuative for my customers. Perhaps by included a "refresh" icon on the page that navigates away from and back to the page? Is this possible? Are there any other methods to achieve this?
5 Replies
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.
Does anyone have any thoughts here? This is blocking my launching the live report and I know my customers won't understand how they must refresh it.
