Please see the follow screen shots.
Hi,
From what I'm seeing there aren't any changes being made from the original data sources to the publishing. Would it be possible to just directly connect to the original data sources in your Tableau workbook and build the extract there instead of in Prep?
If that's not possible then it gets more challenging... Despite the fact that Prep & Server are both made by the same company they are different products and you've hit on the place where the two tools are not well-integrated. The nugget of the issue is:
- Prep can only output single table extracts to the file system and single table Tableau published data sources. It can't (as of current release v2022.4) output a multiple table extract nor a multiple table published data source nor update a single table in a multiple table extract nor multiple table published data source.
- Desktop/Server can join or relate multiple single table extracts or multiple tables in one extract that are available in the file system. However it can't (as of current release) join or relate across published data sources, at this time only blending is supported for that.
My personal wish is that Prep would support outputting multiple table extracts & published data sources, as well as update individual tables in a multiple extract or multiple table extract published data source. In lieu of that here are the options, each has different drawbacks:
- Do all your joins in Prep to output a single table and then use aggregations and LOD expressions as necessary to deal with any replication.
- Use data blending instead of relationships.
- Set up a network drive that Desktop/Server has access to that Prep can write to and Server can read from.
- Use Tableau's REST API (and maybe Hyper API) and build your own pipeline to publish a data source that has multiple tables.
Jonathan
