When you use Data Quality Client to run a data cleanse against a view in SQL Server 2016 Data Quality Services, you receive an error message that resembles the following:
The data source table with id 'DatabaseName.SchemaName.TableName' was not found while adding to the repository. Check whether the table is accessible by DQS.
To work around this problem, use a table instead of a view to perform the cleanse.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 3212227 - Last Review: May 15, 2017 - Revision: 10
Microsoft SQL Server 2016 Developer, Microsoft SQL Server 2016 Enterprise, Microsoft SQL Server 2016 Enterprise Core, Microsoft SQL Server 2016 Standard, Microsoft SQL Server 2016 Service Pack 1