DirectQuery Auto Refresh Dashboard Every 60 Seconds

[blackshep01]

I have a request to create a dashboard that auto-updates every 60 seconds.  This dashboard will be in a hallway for doctors to see their next cases.  I understand that I will need to use DirectQuery.  How do I get the dashboard tiles to auto-update by themselves without having someone hit the refresh button every 60 seconds.   Please help.

[binit]

Hi,

I know this is old thread but Iam curious if you were able to get this working and which approach did you use ? I have a similar requirement of auto refresh every 60 secs with DirectQuery.

[Anonymous]

Hello binit, any solution you've found? I've tried multiple ways without luck. My last attempt was as follow:

1. Extract the data using Azure Data Factory (pipeline with a REST activity to GET the needed data from a API call into a Azure BLOB json format. This pipeline can be triggered and scheduled every 1min or in seconds.

2. Get the data in Power BI directly connecting to the Azure Blob Storage previous created .json file in previous step

However, Power BI is not auto refreshing even though the source data is being updated every min.

[Seth_C_Bauer]

@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-a...

[blackshep01]

@Seth_C_Bauer  The dataset that I am going to use is a  SQL Server dataset.  Will a "Push" dataset work in this instance?

[Seth_C_Bauer]

@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.