Publish the Static Data source to the Tableau Server (don't schedule any refresh).
Connect Tableau Workbook to that Data Source by choosing data source from Tableau Server in Tableau Desktop, you can also add other data sources and add extract schedule.
This should work.
Can you please define exactly what you mean by "static" and "dynamic"?
To me "static" would be a never-changing text file like Excel or .CSV whereas "dynamic" would mean that file is updated fairly often.
"Static" would be an embedded data source, like the Clipboard, and "dynamic" would be a Live or Extract data source.
1 of 1 people found this helpful
Yes, static means never changing content in a csv or excel file. I think Krunal above pointed out that publishing it to the server is a good solution. Embedding a static data source in a workbook will throw an error when the workbook gets refreshed.