Error calling rest api manangement.azure.com from powerbi.com (fail automatic refresh)

Hello,

I've get a try to access azure subscription and ressource information using calls to management.azure.com API. Mainly call to 

https://management.azure.com/subscriptions?api-version=2016-06-01

https://management.azure.com/providers/Microsoft.ResourceGraph/resources?api-version=2019-04-01

My call is using Bearer information for authentification. Calls look like for example:

Source = Json.Document(Web.Contents("https://management.azure.com/" & "subscriptions" & "?api-version=2016-06-01",
[Headers=[#"Authorization"="Bearer " & Bearer1 & ""]])),

Where Bearer1 is a custom functions which look like this:

let
    body = "resource=https://management.azure.com&grant_type=client_credentials&client_id=xxxxxx-xxxx-xxxx-xxxx-xxxxxxxx&client_secret=mySecret",
    Source = Json.Document(Web.Contents("https://login.microsoftonline.com/cegidgroup.onmicrosoft.com/oauth2/token", [Content=Text.ToBinary(body)])),
    access_token = Source[access_token]
in
    access_token

Everything is working suceffuly in my power bi desktop. I can obtains the access token, and suceffuly refresh my datasource.

But when I publish to powerbi.com, the datasource fail to refresh.

If I go in parameters settings to verify the authentification informations, when I do a connection test on my datasource, I obtains this message:

Échec de la mise à jour des informations d'identification de la source de données : The credentials provided for the Web source are invalid. (Source at https://management.azure.com/subscriptions.)Masquer les détails

It seems that the test connection database doesn't pass the Headers information, and so the Bearer.

Do you know of any workaround to this ?

A simple solution would be to check the checkbox "ignore connection test".

But if I do this, it seems that I'm unable to refresh the datasource automatically.

Thanks,

       Laurent.