When you deploy a SSRS project in Visual Studio 2015 to a SQL Server 2016 you may get the error “The shared dataset definition is not valid. Details: The required attribute ‘Name’ is missing.”.
Workaround
Locate the shared dataset file in your file system and open it with your favorite text editor. The beginning of the file should look something like this.
<?xml version="1.0" encoding="utf-8"?>
<SharedDataSet xmlns=...>
<DataSet>
<Query>
<DataSourceReference>sdsSomeName</DataSourceReference>
<CommandText>select * from SomeTable</CommandText>
Just add a Name=”” attribute to the <DataSet> element, save the file and you’re good to go.
The code should now look something like this:
<?xml version="1.0" encoding="utf-8"?>
<SharedDataSet xmlns=...>
<DataSet Name="">
<Query>
<DataSourceReference>sdsSomeName</DataSourceReference>
<CommandText>select * from SomeTable</CommandText>