Smartsheet November 2020 update now can't publish report "The given data source kind is not support

[redlegcraig]

Using PBI Desktop RS October 2020. Create a pbix with a smartsheet connection. Can connect to smartsheet (Okta SSO) and load data, create visuals. When I try to save to newly patched Report Server (Nov. 2020), I get generic error (X an error occurred while attempting to save the report to Power BI Report Server).

When I view the log file on the server (RSPowerBI_DateTime), I see this error:

2021-01-25 11:31:10.1227|ERROR|46|Failed to parse the embedded model data sources| RequestID = s_e9cf8379-a36a-4169-a70a-cad1526eac48 System.NotSupportedException: The given data source kind is not supported. Data source kind: Smartsheet.
at Microsoft.Data.Mashup.DataSourceReference..ctor(String json)
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.GetDataSourcesCollection(String databaseName, TOMWrapper asWrapper)
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.GetDataSourcesInternal(String databaseName, TOMWrapper asWrapper)
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.GetDataSources(String databaseName)
at Microsoft.PowerBI.ReportServer.AsServer.Artifacts.DataModelArtifactsProvider.<RetrieveArtifactsAsync>d__2.MoveNext()
2021-01-25 11:31:10.2008|INFO|46|DeleteDatabase: Successfully deleted model with databaseId=537964612| RequestID = s_e9cf8379-a36a-4169-a70a-cad1526eac48
2021-01-25 11:31:10.2008|INFO|46|RemoveActiveDatabase: DeleteDatabase attempt to remove cached DB from activeModels success=True, databaseId=537964612| RequestID = s_e9cf8379-a36a-4169-a70a-cad1526eac48
2021-01-25 11:31:10.2008|ERROR|18|Failure in reportproperties| RequestID = s_e9cf8379-a36a-4169-a70a-cad1526eac48 System.NotSupportedException: The given data source kind is not supported. Data source kind: Smartsheet.

Why would I be able to create a report in Desktop Report Server but not be able to save it up to the Report Server?
This was working fine before the November patch. Thanks in advance for any help on this.

[jpapmeier · Accepted solution]

We had the same issue, at least regarding to save to the report server. Reports already on the server still work fine. We were able to apply the workaround from:

https://community.powerbi.com/t5/Report-Server/December-2020-Update-Issues-Regarding-Power-BI-Report...

How to Disable Enhanced Dataset Metadata

Note that Desktop authors can control if the enhanced metadata format is used when editing reports. If you are experiencing the above or similar errors, we recommend disabling the options in desktop as follows:

1. Turn off the Enhanced Dataset Metadata option in Power BI Desktop RS
   1.  In Options, under Preview Features, uncheck “Store datasets using enhanced metadata format”

      [Picture here in source]

2. Restart Power BI Desktop for Report Server
3. Restore the old report from the hidden backup in AppData.
   1. Before the file is upgraded to the new format, a backup copy is saved in the app data folder. For example: C:\Users\myuser\AppData\Local\Microsoft\Power BI Desktop SSRS\TempSaves\Backups.
   2. Open the backup and you should be able to save the old version of the report back to the server.

[redlegcraig]

I will also mention an existing report on the Report Server now does not open, it just shows a blank page. Log file shows the same error:

2021-01-25 11:48:53.0873|ERROR|76|Unhandled error in the Web API|GET https://reports.regencycenters.com/powerbi/api/explore/reports/a89fadcb-c9bb-45a8-9c0f-585d60f0b875/... - Response Unknown| RequestID = 0d6ef602-7f66-5688-56c6-cd1a3f1c06cb ClientSessionID = 745edb9a-670d-4f9d-c15e-6ac0b34eb627 System.NotSupportedException: The given data source kind is not supported. Data source kind: Smartsheet.