Semantic Modeling Language (SMDL)

SQL Server 2016+

SMDL models were deprecated as of the release of SQL Server 2014, the ability for them to function was still there. SSRS 2016 or later doesn’t support the Report Models feature.

Uploading and managing report models is a discontinued feature on SQL Server 2016 (is no longer a deprecated feature) and the workaround is explained on the following article:

https://msdn.microsoft.com/en-us/library/ms144231(v=sql.130).aspx

You should try to update reports and remove dependencies on report models.

Sources:

https://social.msdn.microsoft.com/Forums/azure/en-US/d07f0809-c06b-491f-8e1f-bd936cde768c/unable-to-bind-report-model-to-data-source-in-ssrs-2016-native-mode?forum=sqlreportingservices

https://social.technet.microsoft.com/Forums/en-US/34848773-f281-42d8-ba85-a20e7d272e98/what-is-alternate-of-report-modelsmdl-in-sql-server-2016-and-how-to-migrate-smdl-reports-to-sql?forum=sqlanalysisservices

Last modified: September 25, 2020

Author

Comments

Write a Reply or Comment