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.
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
ID d'activité: | df428928-fd75-4bc3-9cec-895bf4dfa5a8 |
ID de demande: | f3ee4b45-1c57-a98f-c1b8-2665fadc31fb |
Code d'état: | 400 |
Heure: | Sat Oct 19 2019 10:10:26 GMT+0200 (heure d’été d’Europe centrale) |
Version du service: | 13.0.11109.192 |
Version du client: | 1910.2.021 |
URI du cluster: | https://wabi-north-europe-redirect.analysis.windows.net/ |
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.
Solved! Go to Solution.
Hi @Anonymous ,
This issue seems to have different reasons. The following post has similar questions to you and provides some solutions, hope to be helpful:
https://community.powerbi.com/t5/Issues/Failed-to-update-data-source-credentials/idi-p/135313
https://community.powerbi.com/t5/Service/Failed-to-update-data-source-credentials/td-p/479063
https://community.powerbi.com/t5/Issues/Web-API-data-source-refresh-issue/idi-p/395836
Best Regards,
Community Support Team _ Joey
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |