Forum Discussion
Enterprise gateway refresh rate
PowerBIlearner Connection types are dictated by what you choose when creating the report. In the Desktop, when you connect to files you will always be importing. When dealing with SQL or sources that allow for Direct Query, you have the option for using that. If you are using SQL Server Analysis Services then you have the option to set up a live connection. The connection types and options are based on what you are initially connecting to.
Based on those, my previous comments about refresh are the same.
Memorable MemberHi PowerBIlearner,
Refreshing frequency does not depend on gateway, gateway just handles moving data from server side to cloud. So the connection mode (Direct Query and Import mode) will define the refreshing rate.
- Direct Query is 15 mintues if there is no interaction from end-user or will refresh when they filter/interactive with charts in report.
- Importing mode is hourly refresh as scheduler
Super Usertringuyenminh92 and Anonymous are correct.
Quick question on 15 minutes refresh, i never saw this working with direct query. I connection Azure SQL and Azure Tabular but dashboard/reports doesn't refresh by itself. I did asked this in AMA but no update from Microsoft. Am I missing something here?
- tringuyenminh92
Hi parry2k,
Reports with Direct Query mode will be refreshed every 15' with "a little bit lagging" (as my observation, i think PBI team has changed from 15' to 40 mintues, but there is no official information about this). I mention about lagging cause there will be dependant performance from responding of your azure db. You could check this from your refresh history (start - end)
For Dashboard, that means tiles, tiles will be refreshed with lagging ~ 1 hour or more as PBI staff confirmed.
That's all what i know about refreshing time ^_^ hope someone in PBI team could share more details.
- parry2k
thanks for the information tringuyenminh92
I never saw it working, even waited for hours but dashboard tiles never refreshed. :(
- tringuyenminh92
Hi parry2k,
Did you try to raise support ticket or something else like issue report. if not, take screenshot history refresh and actual siutation, submit it in issue forum. Hope there is a reason for that.