Forum Discussion
DirectQuery Auto Refresh Dashboard Every 60 Seconds
blackshep01 There are threads on here that have provided solutions such that you would display the report page and have a 3rd party extension refresh the page which should kick off a refresh. Another possible solution that may provide the best route is to use a "Push" dataset. This is essentially using the API's to create a dataset and when you push a refresh the dashboard tiles automatically update.
Info here: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-real-time-streaming/
Another option that I just saw recently but don't know if it applies to your data source off hand would be using Microsoft Flow to Push the data, details here:https://powerbi.microsoft.com/en-us/blog/push-rows-to-a-power-bi-streaming-dataset-without-writing-any-code-using-microsoft-flow/
Anonymous The dataset that I am going to use is a SQL Server dataset. Will a "Push" dataset work in this instance?
blackshep01 I'm not a developer but the answer should be "yes", I'm still digging into this area. It would require custom development, and the examples outlined here should give you an idea if it is something you would want to pursue.