Power BI Report Parameters are not getting updated after the successful execution of the Azure DevOps CICD pipeline.

[anupkosh]

Describe the issue Power BI Report Parameters are not getting updated after the successful execution of the Azure DevOps CICD pipeline using the Pipeline tasks - Power BI Actions : UpdateParameters(Ver: 5.4.48).

Extension

• Extension: Power BI Actions : UpdateParameters
• Version: 5.4.48

[maikvandergaag]

Could you share more info for example log files?

[anupkosh]

5.txt

Please find the attached log files.

[anupkosh]

Waiting for the response. https://github.com/maikvandergaag/msft-extensions/labels/needs-reply

[maikvandergaag]

Hi @anupkosh the label "needs-reply" is a internal thing that's why it was removed. If I look at your log images it seems that it does not find the report.

Could you maybe share the files?

[anupkosh]

Thanks for your response. Specific PowerBI report is already deployed to the respective workspace successfully using the CICD Pipeline tasks - Power BI Actions : Publish(Ver: 5.4.48). Once after the report got uploaded the parameters for the specific report are not getting updated. In the UpdateParameter task , I've selected the checkbox "Update all datasets in workspace the dataset name will be ignored" but no luck. (FYI. Initially I've unchecked this and tried, but no luck) Please find the below screenshot to show you the tasks that I have used in the CICD Pipeline. Please let me know how to proceed further. Thanks.

[maikvandergaag]

Please also share the log file for us to investigate

[anupkosh]

Hi Maik,

Please find the log files attached.Please review it and let me know how to proceed further.

Thanks & Regards, Anup Koshy Jacob

On Wed, Feb 14, 2024 at 9:07 PM Maik van der Gaag @.***> wrote:

Please also share the log file for us to investigate

— Reply to this email directly, view it on GitHub https://github.com/maikvandergaag/msft-extensions/issues/530#issuecomment-1944081749, or unsubscribe https://github.com/notifications/unsubscribe-auth/BGEDCCX4NZCA2IWUDHUR5YDYTTK3NAVCNFSM6AAAAABDGUYCASVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNBUGA4DCNZUHE . You are receiving this because you were mentioned.Message ID: @.***>

[anupkosh]

Waiting for your response.Thanks

[maikvandergaag]

Hi @anupkosh: sorry can't see the log file

[anupkosh]

Yesterday I've sent the logs from my mail id to this email id : reply+BGEDCCWLYCDW3R7ZQPS2EMOD3IILNEVBNHHH6G4ELE@reply.github.com.

Could you please check your email and confirm?

[maikvandergaag]

Checked they are not there.

[anupkosh]

Hi Maik, Please find the attached log files.

Thanks.

On Wed, Feb 14, 2024 at 9:58 PM Anup Koshy Jacob @.***> wrote:

Hi Maik,

Please find the log files attached.Please review it and let me know how to proceed further.

Thanks & Regards, Anup Koshy Jacob

On Wed, Feb 14, 2024 at 9:07 PM Maik van der Gaag < @.***> wrote:

Please also share the log file for us to investigate

— Reply to this email directly, view it on GitHub https://github.com/maikvandergaag/msft-extensions/issues/530#issuecomment-1944081749, or unsubscribe https://github.com/notifications/unsubscribe-auth/BGEDCCX4NZCA2IWUDHUR5YDYTTK3NAVCNFSM6AAAAABDGUYCASVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNBUGA4DCNZUHE . You are receiving this because you were mentioned.Message ID: @.***>

[anupkosh]

Just now I've sent the log files to the email id mentioned in earlier chat. Could you please check it and confirm?

[maikvandergaag]

Still not there try sending it to info at msftplaygound dot com

[anupkosh]

I've sent the logs file to info at msftplaygound dot com. Could you please check it and confirm.

Thanks

[anupkosh]

Still waiting for your response. Thanks

[maikvandergaag]

Hi @anupkosh: Two things:

• Extension is a community effort. This mean I maintain it in my free time so please do not expect to get answers in 5 min.
• Sending the logs might have gone wrong as I did not receive them. Could you maybe add them to the issues?

[anupkosh]

ReleaseLogs_135.zip

Please find the attached logs. Thanks.

[anupkosh]

Please let me know if any update after reviewing the logs. Thanks.

[maikvandergaag]

Hi @anupkosh,

We use following api call on the datasets to retrieve the current parameters: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-parameters

If we have replaced values and if the parameter names are correct. We use this api call: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-parameters

To update the parameters. As the update call is not beign peformed there can be two problems. No found parameters on the dataset or the names are not correctly supplied. Are you maybe able to check by running the powershell locally or doing the api calls?

[allankichowdary]

Same issue for my side also. i am able to update using powershell call but not from task.

[maikvandergaag]

Could you share the code you used?

[allankichowdary]

logs.txt

Please find logs and task.

NOTE : same json is working using powershell.

[allankichowdary]

@maikvandergaag / @anupkosh Also i am looking for some suggestions for automating jobs :

1 . uploading reports and datasets

2. take ownership
3. updating parameters
4. Update gateway 5 Bind the gateway
5. rebind reports to dataset
6. refresh dataset.

is my order correct or any changes are required ? i am having little doubtful about 4 & 5 points about order is correct or only update gateway is fine?

Some time connections are not mapping automatically and we need to select from drop down from setting . please guide here.

[maikvandergaag]

logs.txt

Please find logs and task.

NOTE : same json is working using powershell.

Could you share the peace of powershell that worked for you? To see if there are differences.

[allankichowdary]

before there are 2 apis for fetching data set and workspace id

[maikvandergaag]

What result do you get when calling this api? https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-parameters

[maikvandergaag]

I have a change available in Beta. Would you be able to test? I then need your organization URL to give you access to the beta version.

[allankichowdary]

What result do you get when calling this api? https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-parameters

giving exisitng parameters in dataset

[allankichowdary]

giving existing parameters in dataset

[maikvandergaag]

Closing issues due to no response?

[maikvandergaag]

Issue fixed in new release