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...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

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.

  • sahilpruthi's avatar
    sahilpruthi
    Helper I
    9 years ago
    I made some modifications in db but it doesnt reflect on dashboard.
      • 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.