Error when trying to change PowerBI report parameters with the API

Question

Hi,&nbsp;I am trying the new option within the API with Reporter Server October 2020 version to update parameters. The idea is that the PowerBI report is deployed to different servers and I will update the parameter "servername" with the matching server name.I am following the guide here:&nbsp;https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-source-apisThis works fine unless the parameter contains a special character. In my case&nbsp;Swedish characters like (å). When I want to change the parameter and the parameter value contains this character it shows me this error:"Unable&nbsp;to&nbsp;apply&nbsp;new&nbsp;parameters:&nbsp;System.Collections.Generic.List`1[Model.DataModelParameter]&nbsp;to&nbsp;the&nbsp;datastore&nbsp;due&nbsp;to&nbsp;Microsoft.ReportingServices.Portal.Interfaces.Exceptions.InvalidDataModelParameterException:&nbsp;There&nbsp;was&nbsp;an&nbsp;error&nbsp;uploading&nbsp;your&nbsp;.pbix&nbsp;file.&nbsp;&nbsp;Verify&nbsp;that&nbsp;the&nbsp;file&nbsp;has&nbsp;not&nbsp;been&nbsp;corrupted&nbsp;and&nbsp;that&nbsp;the&nbsp;file&nbsp;extension&nbsp;matches&nbsp;the&nbsp;format&nbsp;of&nbsp;the&nbsp;file.&nbsp;---&gt;&nbsp;System.Net.ProtocolViolationException:&nbsp;Bytes&nbsp;to&nbsp;be&nbsp;written&nbsp;to&nbsp;the&nbsp;stream&nbsp;exceed&nbsp;the&nbsp;Content-Length&nbsp;bytes&nbsp;size&nbsp;specified.
&nbsp;&nbsp;&nbsp;at&nbsp;System.Net.ConnectStream.InternalWrite(Boolean&nbsp;async,&nbsp;Byte[]&nbsp;buffer,&nbsp;Int32&nbsp;offset,&nbsp;Int32&nbsp;size,&nbsp;AsyncCallback&nbsp;callback,&nbsp;Object&nbsp;state)
&nbsp;&nbsp;&nbsp;at&nbsp;System.Net.ConnectStream.Write(Byte[]&nbsp;buffer,&nbsp;Int32&nbsp;offset,&nbsp;Int32&nbsp;size)
&nbsp;&nbsp;&nbsp;at&nbsp;System.IO.StreamWriter.Flush(Boolean&nbsp;flushStream,&nbsp;Boolean&nbsp;flushEncoder)
&nbsp;&nbsp;&nbsp;at&nbsp;System.IO.StreamWriter.Dispose(Boolean&nbsp;disposing)
&nbsp;&nbsp;&nbsp;at&nbsp;System.IO.TextWriter.Dispose()
&nbsp;&nbsp;&nbsp;at&nbsp;Microsoft.ReportingServices.Portal.ODataWebApi.Utils.PbixReportHelper.BuildUpdateDataModelParametersWebRequest(Guid&nbsp;catalogId,&nbsp;IList`1&nbsp;dataModelParameters,&nbsp;String&nbsp;powerBiUri,&nbsp;ILogger&nbsp;logger,&nbsp;IPrincipal&nbsp;userPrincipal,&nbsp;String&nbsp;reportServerHostName)
&nbsp;&nbsp;&nbsp;at&nbsp;Microsoft.ReportingServices.Portal.ODataWebApi.Utils.PbixReportHelper.UpdateDataModelParametersInPowerBI(Guid&nbsp;catalogId,&nbsp;IList`1&nbsp;dataModelParameters,&nbsp;String&nbsp;powerBiUri,&nbsp;ILogger&nbsp;logger,&nbsp;IPrincipal&nbsp;userPrincipal,&nbsp;String&nbsp;reportServerHostName)
&nbsp;&nbsp;&nbsp;at&nbsp;Microsoft.ReportingServices.Portal.ODataWebApi.Common.PowerBIReportsControllerHelper.UpdateDataModelParametersInAS(Guid&nbsp;id,&nbsp;IList`1&nbsp;parameters)
&nbsp;&nbsp;&nbsp;---&nbsp;End&nbsp;of&nbsp;inner&nbsp;exception&nbsp;stack&nbsp;trace&nbsp;---
&nbsp;&nbsp;&nbsp;at&nbsp;Microsoft.ReportingServices.Portal.ODataWebApi.Common.PowerBIReportsControllerHelper.UpdateDataModelParametersInAS(Guid&nbsp;id,&nbsp;IList`1&nbsp;parameters)
&nbsp;&nbsp;&nbsp;at&nbsp;Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.PowerBIReportsController.&lt;PostDataModelParameters&gt;d__33.MoveNext()"&nbsp;I have found som indication as this is an issue with&nbsp;Invoke-WebRequest which is used when I follow the example mentioned earlier.Anyone else seen this issue and found a solution?Stefan&nbsp;

ssce · Answer

I have tested the call to the API using Postman as well with the same error as a result.

So it seems like a bug or is there any setting in the Power BI Report server which I need to set that the API can accept swedish caracters?

v-janeyg-msft · Answer

Hi,&nbsp;ssce&nbsp;&nbsp;Is the type of the parameter text? If the problem can be resolved by changing into universal characters, it should not support Swedish characters. Thanks.&nbsp;Best RegardsJaney Guo&nbsp;If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ssce · Answer

Hi,&nbsp;Yes the parameter is text. Can you suggest a code fragment how to change the text to universal characters and how to post it to the RestAPI?&nbsp;Thx.Stefan

v-janeyg-msft · Answer

Hi,&nbsp;ssce&nbsp;
&nbsp;
If it is a&nbsp; incompatibility problem, it is difficult to change, but we can change ourselves.&nbsp;The most direct and quick way is to change server name which doesn't contain incompatible characters.&nbsp;
&nbsp;
Best Regards
Janey Guo
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

ssce · Answer

It is working fine when the parameter is set when uploaded directly from Power BI Desktop. It seems like it is a bug within the RestAPI.I can work around the issue in this situtation but I can imagine that this is not always possible to do that.

Forum Discussion

Error when trying to change PowerBI report parameters with the API

8 Replies

Related content

Parameter in summarize

notebook parameter

Missing Parameter section in PowerBI Report Server report

Parameters to fabric pipeline

Trying to get Max value using a column parameter