Error combining parameter and custom data connector

[rheuvel]

Hi,

I am trying to combine the output of a Custom Data Connector and a parameter to construct a query using the Web.Contents connector. The Custom Data Connector is used to calculate a Hmac signature and return it as a string. The code looks something like this:

let
    Timestamp = Text.From(DateTimeZone.UtcNow()),
    Authentication = CustomConnector.Contents("SomeBase64Key=", Timestamp),
    BaseUrl = "https://some.apiurl.com",
    Source = Json.Document(Web.Contents(BaseUrl,
        [Query = [Timestamp = Timestamp, Authentication = Authentication, date = Year]]))
in
    Source

Where Year is the parameter with the following code:

"2018" meta [IsParameterQuery=true, Type="Text", IsParameterQueryRequired=true]

Everything works just fine in Power Bi Desktop and the Custom Data Connector works fine with Power Bi service and an On-premise data gateway. Also, just changing the paramater and passing that as a query parameter works in Power Bi Service. However when everything is put together and I try to change the paramter, I get the following error.

Failed to update parameters values.
Please try again later or contact support. If you contact support, please provide these details.

Activity ID a15bd277-cca7-428e-9f56-5ee22d45431b
Request ID c236e830-c5aa-e44b-edf8-654c669f27a8
Correlation ID 1d7d4fe2-80dc-5198-9db3-ff70e7d2d097
Status code 400
Time Tue Sep 03 2019 14:57:51 GMT+0200 (Central European Summer Time)
Version 13.0.10599.151
Cluster URI https://wabi-south-east-asia-redirect.analysis.windows.net

Any help is greatly appreciated.

Kind regards,

Ruurd

[v-lili6-msft]

hi, @rheuvel 

Can you please confirm that you have got the latest version of Power BI On-Premise Gateway.

And if you still have the problem, I would suggest you create a support ticket here.

Provide the details and power bi support team will give you further help.

submit a support ticket

Best Regards,

Lin

[rheuvel]

Hi @v-lili6-msft 

Thanks for the reply.

The Data Gateway shows version 3000.8.452 (August 2019) and Power BI Desktop shows 2.72.5556.801 64-bit (augustus 2019), which, if I am correct, are the latest version.

In any case the request doesn't seem to arrive at the Gateway at all since no errors nor the Request ID show up in the Gateway logs.

For now, unfortunately, creating a support ticket is not something I can do since I have only access to the Pro trial, but not the actual Pro subscription.

It would be good to know if someone else has run into similar problems and if there is a solution.

Kind regards,

Ruurd