Forum Discussion

sahilpruthi's avatar
sahilpruthi
Helper I
9 years ago

desktop

I have created a DirectQuery connection with SQL Azure Database. I am using Power BI (free) for this. I want to confirm whether any change in my database automatically refreshes the reports/dashboar...
sahilpruthi's avatar
sahilpruthi
Helper I
9 years ago

I am using Power BI pro and created a live connection with my database. After publishing the report, when I moved cursor on dataset it is showing "This dataset connects to a source with DirectQuery, which is always up to date. You don't need to schedule a refresh on this dataset".

 

But when i made a change in the database, it doesn't get reflected in the dashboard. What needs to be done to make the dashboard live.

 

Thanks in Advance.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi sahilpruthi,

     

    As you are connecting to Azure SQL database in DirectQuery mode, when you interact with a visualization, queries are sent from Power BI directly to the database. Updated data is then returned and visualizations are updated. If there is no user interaction in a visualization, like in a dashboard, data is refreshed automatically about every fifteen minutes. You can also click "Refresh dashboard tiles" to get updated data in no time.  

     

     

    Reference:
    Databases in the cloud

     

    Best Regards,
    Qiuyun Yu

    • sahilpruthi's avatar
      sahilpruthi
      Helper I
      9 years ago

      Thanks

       

      Is there any service(or any other thing) that updates my dashboard instantly after I made an update in the database.

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Community Support
        9 years ago

        Hi sahilpruthi,

         

        What I mentioned above happens in Power BI Service. When you interact with visual, you can always see the latest data.

         

        Best Regards,

        Qiuyun Yu