Forum Discussion
Connecting to Azure App Config from Power BI
Hello, I have a requirement to connect to the azure app config to read the value of a feature flag from a power bi report.
I tried connecting using the Get Data from Web option. When I try to use my organizational account I get the message "The WWW-Authenticate header doesn't contain a valid authorization URI. Header value: 'HMCA-SHA256,Bearer'"
I tried similar approach as described in this solution as well using the app config id and secret to form the authorization header. This failed with the error "We couldn't authenticate with the credentials provided. Please try again"
Could someone please help with this? I am not sure what I am missing.
Thank you!
Hi Anonymous ,
One possible solution is to use a service principal to authenticate with Azure App Configuration.
The other is to try to get the data through a REST API.
Please refer to the following documents for more information.
Sign in with Azure PowerShell | Microsoft Learn
Work with Azure service principals – Azure CLI | Microsoft Learn
Azure App Configuration REST API | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi Anonymous ,
One possible solution is to use a service principal to authenticate with Azure App Configuration.
The other is to try to get the data through a REST API.
Please refer to the following documents for more information.
Sign in with Azure PowerShell | Microsoft Learn
Work with Azure service principals – Azure CLI | Microsoft Learn
Azure App Configuration REST API | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the suggestions Neeko. I tried using the azure app config rest api but the auth failed. Are there any examples I can refer to on how to set up the auth from power bi for app config service?
The azure app config does not show up as an azure resource, this would have been a very handy feature and allow connection using the org account itself
Hi Anonymous ,
You can refer to the following documents that may be helpful to you:
powerbi - How to generate access token and embed token for service principal? - Stack Overflow
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Has your problem been solved? If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out. Thanks in advance.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Neeko, the rest api method did not work and it also forces secrets to exposed as a way of consuimg the app config api. The service prinicpal method may work but the org has security guidelines which prevent from going down that route. For now, we have paused this option. Will accept the solution since it helped