Published data source contains connection information which is independent on workbooks and can be used by multiple workbooks.
The embedded data source contains connection information but it is associative with the workbooks.