A published data source is one definition of the data, with its joins, calculations and refresh schedule, that many workbooks connect to. Governing it means making it easy to find the right one and hard to use the wrong one.
- Certification marks the source people should trust. It shows wherever the source appears, including when someone connects to data.
- A data quality warning puts a banner on a source and the workbooks that use it: Deprecated, Stale data, Under maintenance, Warning or Sensitive data, with a message saying what to do. Deprecate an old source rather than deleting it, so its workbooks keep working while people move.
- Data source permissions are separate from workbook ones. The View template on a data source already includes Connect; Explore adds Download Data Source.
- Replace Data Source moves a workbook from an embedded or old source to the certified one.
One source to trust, and a clear sign on the one to leave.