Update parameters Task successful but doesn't update the parameters in dataset

[gopinaralasetty]

Describe the issue A clear and concise description of what the issue is.

Extension

• Extension: [Power BI Actions]
• Version: [5*]

Expected behavior Should update the dataset parameters

Situation (please complete the following information):

• Agent type: private agent with windows
• Autentication: service principle
• Extension Version: 5* ReleaseLogs_458.zip

Log info Please add the log file of the agent in debug mode [Add the variable system.debug with the value 'true ' to your pipeline]

Additional information Add any other context about the problem here.

[gopinaralasetty]

@maikvandergaag - The Task is successful, but it doesn't update the parameter in the dataset.

Datasource type is azure databricks and we are using the databricks SQL serverless

[nhvduy]

I ran into the same issue. The Update Parameters task in ADO run successfuly but the Parameters in Admin Portal do not change.

[maikvandergaag]

Could you share logs after you have done with the variable system.debug added with the value true

[nhvduy]

log.txt This is part of the logs after I changed some values, Maik.

[maikvandergaag]

@nhvduy thanks but is this the whole file. I think I miss a part.

[gopinaralasetty]

@maikvandergaag - i have attached all the log in zip file- can you please have a look

[pphidev]

Hi @gopinaralasetty,

Do you 'takeover' the dataset with the service principal before updating the parameters?

Kind regards,

Pim

[nhvduy]

Hi @pphidev how can we takeover the dataset with the service principal? From the workspace setting, user can takeover the dataset, but we cannot loggin as service principal.

[pphidev]

Hi @nhvduy,

You can use the TakeOwnership action.

Example if you use a yml file setup:

- task: PowerBIActions@5
   displayName: 'Take dataset ownership'
   inputs: 
      PowerBIServiceEndpoint: ${{ variables.serviceConnection }}
      Action: 'TakeOwnership'
      DatasetName: ${{ variables.dataSetName }}

Next to that, make sure the parameter type is not set to any in Power BI (Desktop) but to e.g. text. As far as I know, type = any will not work.

Kind regards,

Pim

[gopinaralasetty]

Hi @gopinaralasetty,

Do you 'takeover' the dataset with the service principal before updating the parameters?

Kind regards,

Pim

Hi @pphidev i am using the classic pipeline yes i did takeover the dataset

below are the steps of the task in my release pipeline

[pphidev]

Hi @gopinaralasetty, Do you 'takeover' the dataset with the service principal before updating the parameters? Kind regards, Pim

Hi @pphidev i am using the classic pipeline yes i did takeover the dataset

below are the steps of the task in my release pipeline

Hi @gopinaralasetty,

What is the type of your parameter?

[gopinaralasetty]

Hi @pphidev

The parameter Type is Test

[pphidev]

Hi @pphidev

The parameter Type is Test

Test is (I guess) the value of the parameter. But I refer to the parameter type. The default value for the type is Any. However, Any is not supported by the Power BI API (and therefore also not supported by the Power BI Actions).

Available types are:

[gopinaralasetty]

Sorry for the Typo -- The parameter is Text only

[gopinaralasetty]

@maikvandergaag , can you please check on it

[maikvandergaag]

Still missing some parts in the log.

[github-actions[bot]]

It looks like there hasn't been a reply in 30 days, so I'm closing this issue.