How do I increase Tableau refresh frequency?
I come from a Power BI background at a Microsoft shop. I have a lot of data engineering and analytics experience under my belt. Recently, I moved to a Tableau shop, and I am experiencing issues with the dashboard refreshes, based on what I was told by whoever handed this off to me. Basically, they said Tableau refreshes are based on the server’s capabilities, and the reports draw from our warehouse.
Coming from a Power BI background, once your warehouse refreshed, your Power BI refresh was instantaneous, and your dashboard being up to date quickly was dependent on your data pipeline refreshing. The only time you’d have issues was when you ran live SQL queries against the database, which could cause performance issues. So this is different from what I’m used to.
So I guess my question is: we do have a warehouse where the pipeline refreshes in minutes, but Tableau picking up the changes from the warehouse extract is supposed to refresh every business hour, from six to six. If I calculate it, we just get maybe four to six refreshes during business hours, as opposed to hourly refreshes.