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.
PowerBIlearner The gateway doesn't dictate refresh, it is just the conduit. The connection dictates refresh. Import - 8x per day / Direct Query or Live Connection are "live" and require no refresh to be scheduled.
Thank you Anonymous. So are there 2 types of connection after you set up Gateway? Are they Import and Direct query/ Live connection? Can we pick any of these two? How dies it work? If Import can bring data 8 times a day, what are its advantages over live connection which is Live? TIA.
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.