Unable to Update the Data Source credentials and sql cred while deploying powerbi file through devops.

[ujjwal62000]

Our Scenario:

We manage our Power BI development files (PBIX) in a Git repository hosted within Azure DevOps.
We aim to automate the deployment of these PBIX files to the QA workspace in Power BI using Azure DevOps pipelines.
Desired Pipeline Steps:

Create a Release Pipeline: This pipeline will automate the deployment process.
Utilize Power BI Actions: This extension allows us to perform various actions within the pipeline, including:
Publish File: Upload the PBIX file to the desired workspace.
Take Ownership: Transfer ownership of the published report to a specific user or group in the QA workspace.
Update Data Source: Configure the report to connect to the appropriate data source for the QA environment (different data sources for different workspaces).
Update SQL Parameter: Update any SQL parameters used within the report to point to the correct data in the QA environment.
Refresh Dataset: Trigger a refresh of the dataset to ensure the report reflects the latest data.
Current Issue:

We're facing problems with the "Update Data Source" and "Update SQL Parameter" tasks within the pipeline.

Request for Assistance:

Troubleshooting Help: We'd appreciate any insights into common pitfalls or troubleshooting steps specific to these tasks in an Azure DevOps pipeline utilizing the Power BI Actions extension.
Identifying Root Cause: Your expertise can help us pinpoint the cause of the issues we're encountering.

If you need any further details please ping me over email [email protected]