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.
Hi,
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: https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-source-apis
This works fine unless the parameter contains a special character. In my case Swedish characters like (å). When I want to change the parameter and the parameter value contains this character it shows me this error:
Hi @ssce
With PBI RS May 2022, I had the same issue when I tried to update parameter value with the character 'é'. It seems that the REST API DataModelParameters can't handle character with unicode > 127 (\u007f). I sent a Support Request to Microsoft and they answered:
short update: I was able to fully reproduce your issue. I will check internally if there is a workaround or potential fix. Please understand that this will take some time. |
I will keep you posted.
Have an amzing day!
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?
Hi, @ssce
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.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
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?
Thx.
Stefan
Hi, @ssce
If it is a incompatibility problem, it is difficult to change, but we can change ourselves. The most direct and quick way is to change server name which doesn't contain incompatible characters.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
Hi, @ssce
I find some information about support language.
REST API national language support (ibm.com)
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
14 | |
4 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
6 | |
3 | |
3 |