Forum Discussion
how does import work after data refresh
I believe Anonymous was asking whether the visual would send a request to pull the appropriate data from the SQL DB. If so, then the answer would be 'Yes'.
Anonymous, there is a clear difference between 'Import' and 'Direct Query' with SQL. This article sums them up.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/
Cheers,
D
djnww v-ljerr-msft .. I am describing again what i want to know. First forget about direct query in my scenario.
I am importing my data from Azure SQL DB --> creating some Visuals --> publishing ---> refreshing the data on scheduled time.
Now, I am asking how does my dashboards/Visuals showing data on power bi services. Once i select any filter then how does my data is filtering. Is data flowing back to db ( or some where else like in cache). i know it is in-memory but still from where I am getting my data in visuals.
so, my actual question is, Can i optimize this behaviour further. Suppose dashboard is published and I select one country --India --> visuals are taking time for showing data against India. Can I optimized this time??