search

maikvandergaag / msft-extensions

Repository for extensions mainly used for Azure DevOps Extensions
https://msftplayground.com
MIT License
125 stars 81 forks source link

PowerBI not updating the parameters. #499

Closed judeaugustinej closed 1 year ago

judeaugustinej commented 1 year ago

Describe the issue We need to publish report , update the parameters and refresh, but pipeline is successful but parameter value not updating.

Extension

To Reproduce Steps to reproduce the behavior:

Step 1: Power BI Action: Publish Step 2: Power BI Action: TakeOwnership Step 3: Power BI Action: UpdateParameters

[{'Server' : 'txxxxx', 'Number' : '200'}] Step 4: Power BI Action: Dataset refresh

Expected behavior

when i check the setting in dataset the Number should be 200, but it is not changing ie old number is there.

Situation (please complete the following information):

judeaugustinej commented 1 year ago

log from azure devops pipeline

2023-08-11T04:57:44.3059461Z ##[section]Starting: Power BI Action: upload report 2023-08-11T04:57:44.3188714Z ============================================================================== 2023-08-11T04:57:44.3188893Z Task : Power BI Actions 2023-08-11T04:57:44.3188978Z Description : Release Task Power BI Actions 2023-08-11T04:57:44.3189099Z Version : 5.4.44 2023-08-11T04:57:44.3189181Z Author : Maik van der Gaag 2023-08-11T04:57:44.3189847Z Help : 2023-08-11T04:57:44.3189927Z ============================================================================== 2023-08-11T04:57:45.5139019Z Starting Power BI Actions extension 2023-08-11T04:57:45.5344039Z ### Required Module is needed. Importing now... 2023-08-11T04:57:45.6948651Z ### Trying to import the incorporated module for PowerBI 2023-08-11T04:57:47.9033376Z Getting Power BI Workspace properties; WorkSpace 2023-08-11T04:57:49.3255636Z Trying to publish PowerBI File: D:\a\r1\a_PowerBI-CI-CD-using-AzureDevops\drop\my-reportPowerBI.pbix 2023-08-11T04:57:49.3300112Z Checking for existing Reports with the name: my-reportPowerBI 2023-08-11T04:58:08.2733602Z Done processing Power BI Actions 2023-08-11T04:58:08.2737343Z Done running Power BI Actions extension. 2023-08-11T04:58:08.3629801Z ##[section]Finishing: Power BI Action: upload report

2023-08-11T04:58:08.3661217Z ##[section]Starting: Power BI Action: take ownership 2023-08-11T04:58:08.3795089Z ============================================================================== 2023-08-11T04:58:08.3795266Z Task : Power BI Actions 2023-08-11T04:58:08.3795348Z Description : Release Task Power BI Actions 2023-08-11T04:58:08.3795467Z Version : 5.4.44 2023-08-11T04:58:08.3795544Z Author : Maik van der Gaag 2023-08-11T04:58:08.3795632Z Help : 2023-08-11T04:58:08.3795694Z ============================================================================== 2023-08-11T04:58:09.3787454Z Starting Power BI Actions extension 2023-08-11T04:58:09.3980249Z ### Required Module is needed. Importing now... 2023-08-11T04:58:09.5553205Z ### Trying to import the incorporated module for PowerBI 2023-08-11T04:58:10.6296226Z Trying to take ownership of the dataset 2023-08-11T04:58:10.6428616Z Getting Power BI Workspace properties; WorkSpace 2023-08-11T04:58:11.6506028Z Processing dataset - my-reportPowerBI 2023-08-11T04:58:11.8357420Z 2023-08-11T04:58:11.8369965Z Ownership taken for Dataset- 'my-reportPowerBI' 2023-08-11T04:58:11.8398033Z True 2023-08-11T04:58:11.8400763Z Done processing Power BI Actions 2023-08-11T04:58:11.8403392Z Done running Power BI Actions extension. 2023-08-11T04:58:11.8779630Z ##[section]Finishing: Power BI Action: take ownership

2023-08-11T04:58:11.8820630Z ##[section]Starting: Power BI Action: update parameter 2023-08-11T04:58:11.8947673Z ============================================================================== 2023-08-11T04:58:11.8947843Z Task : Power BI Actions 2023-08-11T04:58:11.8947942Z Description : Release Task Power BI Actions 2023-08-11T04:58:11.8948043Z Version : 5.4.44 2023-08-11T04:58:11.8948147Z Author : Maik van der Gaag 2023-08-11T04:58:11.8948242Z Help : 2023-08-11T04:58:11.8948305Z ============================================================================== 2023-08-11T04:58:12.8548124Z Starting Power BI Actions extension 2023-08-11T04:58:12.8745382Z ### Required Module is needed. Importing now... 2023-08-11T04:58:13.0319544Z ### Trying to import the incorporated module for PowerBI 2023-08-11T04:58:14.0224188Z Trying to update the dataset parameters 2023-08-11T04:58:14.0313238Z Getting Power BI Workspace properties; WorkSpace 2023-08-11T04:58:14.6159277Z Processing dataset - my-reportPowerBI 2023-08-11T04:58:20.7177537Z Done processing Power BI Actions 2023-08-11T04:58:20.7179114Z Done running Power BI Actions extension. 2023-08-11T04:58:20.7521661Z ##[section]Finishing: Power BI Action: update parameter 2023-08-11T04:58:20.7546912Z ##[section]Starting: Power BI Action: refresh 2023-08-11T04:58:20.7668960Z ============================================================================== 2023-08-11T04:58:20.7669136Z Task : Power BI Actions 2023-08-11T04:58:20.7669219Z Description : Release Task Power BI Actions 2023-08-11T04:58:20.7669320Z Version : 5.4.44 2023-08-11T04:58:20.7669420Z Author : Maik van der Gaag 2023-08-11T04:58:20.7669507Z Help : 2023-08-11T04:58:20.7669570Z ============================================================================== 2023-08-11T04:58:21.7691698Z Starting Power BI Actions extension 2023-08-11T04:58:21.7889923Z ### Required Module is needed. Importing now... 2023-08-11T04:58:21.9521518Z ### Trying to import the incorporated module for PowerBI 2023-08-11T04:58:23.0445924Z Trying to refresh Dataset 2023-08-11T04:58:23.0558263Z Getting Power BI Workspace properties; WorkSpace 2023-08-11T04:58:23.6371020Z Processing dataset - my-reportPowerBI 2023-08-11T04:58:23.7574400Z 2023-08-11T04:58:23.7580123Z Done processing Power BI Actions 2023-08-11T04:58:23.7583824Z Done running Power BI Actions extension. 2023-08-11T04:58:23.7936266Z ##[section]Finishing: Power BI Action: refresh

judeaugustinej commented 1 year ago

update paramter is successful in azure devops pipepline but the value is not getting updated in power bi dataset.

conorh-devops commented 1 year ago

@judeaugustinej Are you able to update parameters in a report via the API?

https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-parameters-in-group

If not then the extension probably cannot update them either as it uses this API.

I could not update Dataflow parameters with the extension, but I can update Dataset parameters perfectly with extension.

maikvandergaag commented 1 year ago

Because of no more response closing this issue