Execute Power BI deployment from Azure Pipeline

[kalluu91]

Hello experts,

I have created a Power BI Deployment pipeline and I have invoked this pipeline from an Azure DevOps Pipeline using the Power BI Automation Tool extension.

Everything works fine except when I deploy with the service account, the report does not work anymore because the data source credentails is not correct.

Do you have any solution/suggestions?

Here is my step in azure devops pipeline:

```

- task: DeploymentPipelines-Deploy@1

  displayName: "Deploy reports"

  inputs:

    pbiConnection: "POWER_BI_CLIENT"

    pipeline: "$(pipelineid)"

    stageOrder: "Test"

    waitForCompletion: true

    deployType: "All"

    createNewWS: false

    allowCreateArtifact: true

    allowOverwriteArtifact: true

    updateApp: false

    allowOverwriteTargetArtifactLabel: false

    allowPurgeData: false

    allowSkipTilesWithMissingPrerequisites: false

    allowTakeOver: true

```

Thanks a lot,

Kim Anh

[v-shex-msft · Accepted solution]

HI @kalluu91,

I'd like to suggest you double check if the service account you used to deploy the reports has the corresponding permissions to access the data source. (the service account should have required credentials and access rights to connect to the data source)

If the service account does not have the correct credentials, you can update the data source credentials in the Power BI report before deploying it.
For the methods to update credentials, you can choose to manually verify the data source credentials or use the Power BI REST API/PowerShell cmdlets to update the data source credentials programmatically.

How to Change Data Source Credentials in Power BI 

Documentation about update data source credentials using the Power BI REST API:

Datasets - Update Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Regards,

Xiaoxin Sheng