Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to Change the data sources and Update Parameter using Power BI Actions #545

Open
nikmk05 opened this issue Apr 15, 2024 · 1 comment
Assignees
Labels

Comments

@nikmk05
Copy link

nikmk05 commented Apr 15, 2024

We are working on CICD Pipeline using Power BI Actions in Azure DevOps.

cicd

We created release pipeline using Power BI Actions, we got the output for Publishing, adding user, creating workspaces.
But
for our case, we have 2 environments, Dev and Test.

We are using SQL Server as Datasource.
we have 2 databases DEV_Database for DEV environment and Test_Database for Test environment.
As of now, we are using DEV_database for developing reports.
We are trying to publish the report from DEV to Test workspaces. We need to use Test_database in Test workspace. Therefore, we are trying to do this using parameters. But Power Bi actions showing "Bad request " and "Invalidstatus " like this.

Please consider this request and help me to find the solution.

Thanks.

@pphidev
Copy link

pphidev commented May 7, 2024

Hi @nikmk05,

Can you provide more details on the settings that you use for the release pipeline?

Example if you use the Power BI Actions in a yml file:

- task: PowerBIActions@5
   displayName: 'Update parameters'
   inputs:
      PowerBIServiceEndpoint: ${{ variables.serviceConnection }}
      Action: 'UpdateParameters'
      WorkspaceName: ${{ variables.powerbiWorkspace }}
      DatasetName: ${{ variables.dataSetName }}
      ParameterInput: '[{"name":"Environment","newValue":"${{ parameters.env }}"}]'

In above example, the parameter env stores the reference to the environment (e.g. dev, acc, test etc.).

Kind regards,

Pim

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants