Forum Discussion

blackshep01's avatar
blackshep01
Frequent Visitor
9 years ago

DirectQuery Auto Refresh Dashboard Every 60 Seconds

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.

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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/

    • blackshep01's avatar
      blackshep01
      Frequent Visitor
      9 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        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.

  • binit's avatar
    binit
    New Member
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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.