1 of 1 people found this helpful
Here are my responses to your questions below:
1. Currently I have a live connection with initial sql. When I switch it to extract will initial query still work ?can I have initial sql and use extract connection
2. Would publishing an empty extract and connecting workbook to it help ?
Help in doing what? How/when would the data be refreshed then?
3. Or should I generate an extract of sql server view and publish it to tableau server ??
This may be a better option. You can then connect to this data source and apply filters as required for the security.
Thanks for the answers , will give it a try. Regarding point 2 I want to publish an empty extract and let servers refresh it with data, because generating full data extract might take a while