Last Modified Date: 07 Aug 2021
- Tableau Server 2021.1.1
- MS SQL Server
ResolutionThis is expected behavior since Initial SQL is not run when the view is refreshed. The initial SQL command will run when a connection is made to the database, for example, when you open the workbook, refresh an extract, sign in to Tableau Server, or publish to Tableau Server. Initial SQL is not run when your refresh your view.
As workaround one of the following options can be used:
Since Initial SQL will run when an extract is refreshed, use extract instead of live data and schedule the extract to be refreshed based on desired frequency.
Option 2:Use view or stored procedure in SQL Server.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials