data refresh for DirectQuery

[Anonymous]

There is a table on the report which is driven from a direct query call to sql server.
Question:
Every time I click on one of the columns to sort the data, is the data being pulled back from sql server or is it cached in power BI model?
I ask because every time on sorting, it takes a long time for the table to refresh...

Thank you

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

When you are sorting the data,it first sends a query to sql server,then gets the data you need back to power bi.In directquery mode,only the table name and column headers are caching in power bi.That is why you cant see data view in direct query.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

Thank you

[amitchandak]

@Anonymous , It queries only when new data is required.

There is some cache option in premium: https://powerbi.microsoft.com/en-us/blog/announcing-query-caching-in-power-bi-premium/

You can check queries on the profile. Check option in article

https://radacad.com/directquery-connection-in-power-bi-how-does-it-work-limitations-and-advantages