Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
An error is received when trying to save to RS. I don't know how to resolve this issue, so any help is greatly appreciated.
This is a new install of PBI report server and Power BI Desktop for RS. Also upgraded SQL Server 2016 to SQL Server 2019 and has SSRS installed prior to install of PBI report server.
I've review the logs on the server an copied pertinent information below.
The following log error from RSPowerBI log:
2021-02-05 09:14:28.3367|ERROR|11|Failure in reportproperties| RequestID = s_526cf459-91e1-4dd5-ba8b-3fc13d6917d3 Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to publish model for temp_049b79d8-c948-448c-8f19-4e764ceb8170 ---> Microsoft.AnalysisServices.OperationException: 1520 is not a valid value for this element.
An error occurred while parsing the 'ddl200:CompatibilityLevel' element at line 1, column 3179 ('http://schemas.microsoft.com/analysisservices/2010/engine/200' namespace) under Load/ObjectDefinition/Database/CompatibilityLevel.
An error occurred when loading the 'temp_049b79d8-c948-448c-8f19-4e764ceb8170', from the file, '\\?\D:\Program Files\Microsoft Power BI Report Server\PBIRS\ASEngine\workspaces\1225748903.1.db.xml'.
at Microsoft.AnalysisServices.XmlaClient.SendExecuteAndReadResponse(Boolean skipResults, Boolean throwIfError, Boolean useBinaryXml)
at Microsoft.AnalysisServices.XmlaClient.ImageLoad(String databaseName, String databaseId, Stream sourceDbStream, Boolean allowOverwrite, String readWriteMode)
at Microsoft.AnalysisServices.Core.Server.ImageLoad(ImageLoadInfo imageLoadInfo)
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.<>c__DisplayClass24_0.<LoadDatabaseInAsAsync>b__0()
--- End of inner exception stack trace ---
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.<>c__DisplayClass24_0.<LoadDatabaseInAsAsync>b__0()
at System.Threading.Tasks.Task`1.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.<LoadDatabaseAsync>d__8.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportServer.WebApi.PBIX.DataModelArtifactsProvider.<RetrieveArtifactsAsync>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportServer.WebApi.PbiApi.PbiApiController.<ShredWithModel>d__41.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportServer.WebApi.PbiApi.PbiApiController.<ShredFromPreshreddedFiles>d__31.MoveNext()
Log RSPortal:
2021-02-05 09:59:12.5524|INFO|6|Received request GET /api/v2.0/ServiceState| RequestID = s_f6a529da-8b36-468a-afbc-8813cc3f96f8
2021-02-05 09:59:12.5681|INFO|6|Sending response. Response code VALINOR\joe.sampson 200, Elapsed time 0:00:00.0125756| RequestID = s_f6a529da-8b36-468a-afbc-8813cc3f96f8
2021-02-05 09:59:13.4587|INFO|6|Received request GET /api/v2.0/CatalogItems(Path='/')| RequestID = s_abe5cb4b-4a2d-4a49-98c0-601581650986
2021-02-05 09:59:13.4587|INFO|6|Sending response. Response code VALINOR\joe.sampson 200, Elapsed time 0:00:00.0044923| RequestID = s_abe5cb4b-4a2d-4a49-98c0-601581650986
2021-02-05 09:59:13.5369|INFO|6|Received request GET /api/v2.0/catalogitems(b7095076-6c65-43e2-a6ee-709f35ac89bc)/Model.Folder/catalogitems/| RequestID = s_fed35560-268e-4b23-aacf-aa3a16659849
2021-02-05 09:59:13.5525|INFO|57|Sending response. Response code VALINOR\joe.sampson 200, Elapsed time 0:00:00.0198963| RequestID = s_fed35560-268e-4b23-aacf-aa3a16659849
2021-02-05 09:59:17.8217|INFO|6|Received request GET /api/v2.0/CatalogItems(Path='/Member')| RequestID = s_95c6e16e-ee57-4313-9103-e263db2bfcb9
2021-02-05 09:59:17.8217|INFO|6|Sending response. Response code VALINOR\joe.sampson 404, Elapsed time 0:00:00.0032116| RequestID = s_95c6e16e-ee57-4313-9103-e263db2bfcb9
2021-02-05 09:59:21.7149|INFO|6|Received request GET /api/v2.0/System/Properties| RequestID = s_8a16ad18-2536-4928-980d-0f37374ff010
2021-02-05 09:59:21.7149|INFO|6|Sending response. Response code VALINOR\joe.sampson 200, Elapsed time 0:00:00.0025768| RequestID = s_8a16ad18-2536-4928-980d-0f37374ff010
2021-02-05 09:59:21.7306|INFO|6|Received request GET /api/v2.0/me| RequestID = s_2ead395b-574a-400c-af6e-49ebabb4b838
2021-02-05 09:59:21.8868|INFO|6|Sending response. Response code VALINOR\joe.sampson 200, Elapsed time 0:00:00.1556899| RequestID = s_2ead395b-574a-400c-af6e-49ebabb4b838
2021-02-05 09:59:22.0900|INFO|6|Received request POST /api/v2.0/powerbireports(Path='/Member')/Model.Upload| RequestID = s_11e814e3-1100-4d2c-baca-c142646a07d8
2021-02-05 09:59:24.8870|ERROR|50|The remote server returned an error: (400) Bad Request.| RequestID = s_11e814e3-1100-4d2c-baca-c142646a07d8
2021-02-05 09:59:24.9026|INFO|55|Sending response. Response code VALINOR\joe.sampson 422, Elapsed time 0:00:02.8155495| RequestID = s_11e814e3-1100-4d2c-baca-c142646a07d8
Solved! Go to Solution.
Oh, the RS build is 15.0.1102.777, Jan 2020. Desk top is most current Jan 2021. The RS build was supposed to be the latest, looks like the OPS team installed the 2020 version by mistake.
Do you think this is the issue?
Yes, it is issue (but I don't if only one). But sure, upgrade RS to latest version (January 2021 (be sure released 28th Jan, not 8th Jan).
Desktop RS must same release version or older (not newer) as server. And also January 2020 version is now unsupported.
"...and has SSRS installed prior to install of PBI report server." You have SSRS still installed, or is uninstalled and replaced by PBIRS? It is on same machine, it is all on one machine?
Which version of PBIRS and which version of PBI Desktop RS you have installed? I think compatiblity level 1520 is about May maybe Oct 2020 Release...
Oh, the RS build is 15.0.1102.777, Jan 2020. Desk top is most current Jan 2021. The RS build was supposed to be the latest, looks like the OPS team installed the 2020 version by mistake.
Do you think this is the issue?
Yes, it is issue (but I don't if only one). But sure, upgrade RS to latest version (January 2021 (be sure released 28th Jan, not 8th Jan).
Desktop RS must same release version or older (not newer) as server. And also January 2020 version is now unsupported.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
10 | |
5 | |
3 | |
3 |