Forum Discussion

kalluu91's avatar
kalluu91
Regular Visitor
2 years ago
Solved

Execute Power BI deployment from Azure Pipeline

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

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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