Forum Discussion

pabeader's avatar
pabeader
Icon for Post Patron rankPost Patron
3 years ago
Solved

Direct Query Data not Refreshing

I'm on the latest version of Power BI Desktop.  I create a Direct Query connection to a SQL data source.  In Transform data I can see the new data coming in when I refresh.  Filter the data to the la...
  • v-yanjiang-msft's avatar
    3 years ago

    Hi pabeader ,

    From the document can see:

    With DirectQuery, when you create or interact with a visualization, you must query the underlying source. The time that's needed to refresh the visualization depends on the performance of the underlying data source. If the data needed to service the request was recently requested, Power BI Desktop uses the recent data to reduce the time required to show the visualization. Selecting Refresh from the Home ribbon refreshes all visualizations with current data.

    You can also use Performance Analyzer to view the queries that Power BI sends to the data source, and their execution times.

     

    Best regards,

    Community Support Team_yanjiang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.