Forum Discussion
Does Direct Query fires a TSQL query on the database each time whenever a record is inserted/updated
Hi Team,
I want to understand some few points with respect to Direct Query mode in Power BI.
Suppose I have built my report using Direct Query mode and have published the report on the Services. There are say 40M rows in the dataset. Now if a new record is inserted today in the database. Will Power BI refresh all the previous 40M rows along with the new row to include it in the visualization or will it refresh only the new row that is inserted whenever any visualization is changed by changing the slicer selection.
Any help would be highly appreciated. Please let me know for any additional details required.
Thanks,
Ani
3 Replies
HI Ani26
using the connection mode "direct query" mode means:
- your data will not be copied into the Power BI data model
- whenever a user interacts with a visual (a slicer, a barchar ...) queries will be generated that are querying the data source, for this reason it is valid to say that the visuals will show the most recendt data. But the report will not update automatically, just due user interaction, you need click REFRESH button.
Regards,
Lin
Hi v-lili6-msft
Thank you for your reply.
I understand that in Direct Query mode the data is not copied to the Power BI model. But when the data is in TB then won't Power BI take too much time to fetch the results on every user interaction. What would be the best solution in this scenario?
Thanks,
Ani
HI Ani26
For the cache of the browser, you just need to click refresh bottom of report or refresh the browser, then it will ok.
Regards,
Lin
