Dataset refresh : successfull via PBI-Desktop, but erroneous after publish to PBI-Service

[Anonymous]

1.) I created a web connection via REST API to a webapp calles YNAB:

2.) Authentification is done via "Web" connection

Please be aware that the Authorization is done via the HTTP Parameter, with the "Bearer Token".

3.) If I now publish the PBI-Report to the PBI-Service then I can see the same date as I saw in PBI-Desktop.

4.) But when I try to refresh the report, I get en error :

5.) The Problem is, that the Authentification is done inside the query. Therefore those values here have to be "Empty" and "Anonymous".

Thats also the case at the beginning, when I created the data connection.

Any Idea how I can connect to my webapp, so that I would be able to refresh the dataset ?

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

I'd like to suggest you to add 'relative path' optional parameter to your web connector to use anonymous mode and internal authorization keys as data credentials.

Source=Web.Contents("https://api.youneedbudget.com", [Headers=[Authorization=xxxxxxxxx],RelativePath="/v1/budgets"])

Regards,

Xiaoxin Sheng