Skip to main content

    Power BI

    Needs Votes

    DirectQuery run automatically every x seconds

    Vote (3) Share
    Frank Thomson's profile image

    Frank Thomson on 30 Aug 2016 01:40:46

    I want to show a 'live' count of records in my database. Currently i have a directquery with count(*) which gets run when the dashboard refreshes. I want this to happen automatically every x seconds.

    Comments (2)
    Frank Thomson's profile image Profile Picture

    Tarek Salha on 05 Jul 2020 22:51:07

    RE: DirectQuery run automatically every x seconds

    I would rather suggest you to the newly introduced streaming datasets in Power BI. They offer you the ability to display always the newest data without having the need to refresh at all.

    Frank Thomson's profile image Profile Picture

    Bryan Swan on 05 Jul 2020 22:44:03

    RE: DirectQuery run automatically every x seconds

    You should check out the caching it's new in Power BI. https://powerbi.microsoft.com/en-us/blog/announcing-custom-cache-refresh-schedules-in-the-power-bi-service/