SqlSetup: Missing Role Parameters : SPI_AS_ExistingFarm, SPI_AS_NewFarm, AllFeatures_WithDefaults

Details of the scenario you tried and the problem that is occurring

This issue is created to bring some improvements to the SqlSetup DSC Configuration. The idea is to report all the missing options in the resource to be allow the installation of all the features and to use all the options available in the SQL Server installer.

Role Parameters to add :

SPI_AS_ExistingFarm : Installs Analysis Services as a Power Pivot named instance on an existing SharePoint Server 2010 farm or standalone server.
SPI_AS_NewFarm : Installs Analysis Services and Database Engine as a Power Pivot named instance on a new, un-configured Office SharePoint Server 2010 farm or standalone server. SQL Server Setup will configure the farm during feature role installation.
AllFeatures_WithDefaults : Installs all features that are available with the current edition.

The DSC configuration that is using the resource (as detailed as possible)

SqlSetup

Version of the operating system and PowerShell the target node is running

Windows Server 2012/2012R2/2016

SQL Server edition and version the target node is running

SQL Server 2012/2014/2016/2017

What SQL Server PowerShell modules, and which version, are present on the target node.

Most recent version

Version of the DSC module you're using, or write 'dev' if you're using current dev branch

Most recent version

Start with the SqlSetup DSC resource and trace how role parameters are defined and passed to SQL Server Setup. Add support for SPI_AS_ExistingFarm, SPI_AS_NewFarm, and AllFeatures_WithDefaults, preserving the stated behaviors across the listed SQL Server versions; completion should allow these roles to be selected by the resource.