Forum Discussion

rakesh_singh's avatar
rakesh_singh
Regular Visitor
9 years ago
Solved

How to auto refresh report data using direct query ?

Hello,   I have created a report in Power BI desktop using DIRECT QUERY option then i have saved and published it.   Then after i have inserted a new record in that table which is using in this r...
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi rakesh_singh,

    As per this article, in Power BI Service, if your dataset is configured for a DirectQuery connection, there is a direct connection between Power BI and the database, there is no need to schedule refreshed, and datasets are refreshed approximately each hour or when interaction with the data occurs.

    In addition, do you use “Publish to web” feature and embed Power BI reports in your application? And you note that the report in your application is not updated after inserting a new record in the table? If that is the case, according to this document, data refreshes are automatically reflected in your embedded report or visual,  after refresh occurs in Power BI Service reports , it can take approximately 1 hour for refreshed data to be visible from embed codes.

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

But if we need to refresh the data without an interaction with the report. As in automate the refresh button, with the ability to refresh every 1-60 seconds.

 

 

In our case we´ve built a report for a monitor-dashboard that needs to be refreshed at least every third second,
This is a way to keep working with measures and get the sensation of "realtime" reporting

 

We´ve tried, streaming, push and hybrid but we can´t use measures (REST API is not an option)
We need this, asap

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi - did you find a solution to this problem?

     

    We're currently experiencing a similar requirement - as I understand it, DirectQuery can refresh every 15mins, or on a users click, but we need the report to refresh more often than this, and without any user interaction (The report is going to be displayed on a large screen for customers to see at any point with live, or as close to live as possible, information).

     

    Any ideas?

     

    Thanks,

    Vicky

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Any news / solution to this problem?

       

      We have the same situation: DirectQuery (or even mixed) Dataset published in a "publish-to-web Version".

      Is there any way to disable the Webcache and force an automatic refresh?

      I thought about a button to send a query to the DirectQuery connection but I do not have a solution yet...

       

      Any ideas?