Issue with PowerBIDatasetRefreshOperator in Airflow: Authentication Error
I’m currently using Airflow to orchestrate some notebooks in Microsoft Fabric. My setup leverages the FabricUser connection and FabricRunItemOperator for earlier steps, and everything works smoothly up to this point. However, when I attempt to use the PowerBIDatasetRefreshOperator in the final step with the same FabricUser connection, I encounter the following error: Authentication failed: AADSTS7000215: Invalid client secret provided. Ensure the secret being sent in the request is the client secret value, not the client secret ID, for a secret added to app 'b39a6123-149f-4fad-8659-55f249cb5e9a'. Trace ID: 9516efd5-2ead-4059-8cae-957fdd72f600 Correlation ID: 8ec4dfbf-8e41-497e-aaec-1061d6204919 Timestamp: 2024-11-27 16:17:48Z What I’ve Tried Verified the connection details for the FabricUser. Checked the app registration in Azure Active Directory to ensure the client secret is correctly configured. Confirmed that the secret being used is the client secret value, not the client secret ID. Despite these checks, the issue persists. My Questions Is there a specific configuration or prerequisite I might be missing when using PowerBIDatasetRefreshOperator in conjunction with the FabricUser connection? Are there any known limitations or best practices for using this operator in Airflow with Microsoft Fabric? How can I ensure that the authentication process works consistently for this operator? Thank you in advance for your help.
