Sharing a workbook that connects to Tableau Server postgres and maps data sources and respective workbooks.
Notice the first column (highlighted in blue) reports if the data source is a Published data source (if not published, then the data source is embedded)
As well as relationship between data source and workbook ...
the Tooltip has information on Site Name, Project Name, Owner Friendly name, Extract/Incremental Extract
Hope this workbook is helpful!