This content has been marked as final. Show 1 reply
1 of 1 people found this helpful
Yeah, data sources on Server are a bit confusing. I've annotated your picture to help with the explanation:
- You get data source 1 in your first step. This is the only step in which you create a published data source, which is a data source that has its own, independent existence. You can tell this by the cylinder icon I've highlighted in region A. This points to something other than a data source, which you can see by the icon in region B.
- In your second step, you downloaded data source 1, which really does create a local copy that is not at all connected to data source 1 on the server. When you publish this workbook, you get a second data source -- data source 2 -- that points to the same external system as data source 1, but is embedded in the workbook. Embedded data sources are really part of the workbook, and don't have an independent existence.
- In your third step, you created a workbook that was connected to data source 1, and then published this workbook. The workbook needs a pointer to where it reads its data, and an embedded data source is Server's mechanism for doing this. The result is that you get data source 3, but this embedded data source doesn't point to the external system; it points to data source 1.
Hope this helps!