Forum Discussion

sahilpruthi's avatar
sahilpruthi
Icon for Helper I rankHelper 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/dashboards?

 

Regards,

Sahil

7 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Yes and no. Since you are using DirectQuery, you are querying the data live. So, there is no automatic refresh, each time you view the report/dashboard it is querying the database and coming back with the latest information.