Proxies are not set when using microsoft-azure provider for Power BI

[morelgeorge]

Apache Airflow Provider(s)

microsoft-azure

Versions of Apache Airflow Providers

• apache-airflow-providers-microsoft-azure 12.10.1

Apache Airflow version

3.1.3

Operating System

Rhel 9.6

Deployment

Virtualenv installation

Deployment details

No response

What happened

Hello,
we are facing an issue when we are trying to connect to a Power BI using standard proxies attribute. We are using proxies parameters like following:

{
"http": "http://{Username}:{Password}@{ProxyURL}:{Port}"
"https":"http://{Username}:{Password}@{ProxyURL}:{Port}"
}

However, the MSAL Proxy parameter that is used when communicating with Azure services is still set to None. Based on our testing it is because of missing Authority variable which is not retrieved from the connection.

We are using Power BI connection using Service Principal account with ClientID, Secret and Tenant parameters filled.

What you think should happen instead

In KiotaRequestAdapterHook function to_msal_proxies is a statement that sets up proxies to None in case there is missing Authority or Proxies. That is the root cause of the issue. We do not retrieve Authority value from connection.

How to reproduce

Test connection to a Power BI service with using proxies parameter.

Anything else

I am not sure why the Authority is needed in this case. We can fix it by updating the if statement in to_msal_proxies function, but I am not sure if it is correct approach.

Also, one interesting thing - In the DAG log all proxies values are written, even when they are using sensitive values. The Redact function does not work properly.

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct