Power Bi Action : Update Parameters

[itsmethereddy]

Describe the issue Our requirement is to deploy PBI report to Test and Prod environments from Dev, As part of that we have a deployment pipeline created, and assigned three workspaces to three environments. Then using task deploy content we have moved one report to test environment and used Power Bi action take ownership which also worked fine and as a result service principal took over the dataset. Finally i have used Power Bi action Update Parameters to change the data source parameters (server name and database name) in test environment. However this task also succeeded but failed to update parameters in Power BI. Devops pipeline is succeeding and parameters are not being updated.

Extension

• Extension: [Power Bi Actions]
• Version: [5.*]

Expected behavior For the Power BI dataset, Parameters like database and server should be updated in the data source settings.

Situation

• Agent type: Windows 2019
• Autentication: Service connection
• Extension Version: 5.4.54

Log info ReleaseLogs_157.zip

Additional information Can you please help on this?

[maikvandergaag]

Could you share more info? The update parameters are in correct

Groetjes,

Maik van der Gaag

---

Van: Michael J. Oria @.> Verzonden: Sunday, June 23, 2024 2:53:34 PM Aan: maikvandergaag/msft-extensions @.> CC: Maik van der Gaag @.>; Assign @.> Onderwerp: Re: [maikvandergaag/msft-extensions] Power Bi Action : Update Parameters (Issue #550)

Hello - I am currently experiencing the same problem.

Here is my request body JSON:

{"updateDetails": [{"name":"DBServer","newValue":"testServer"}, {"name":"DBName","newValue":"testDB"}, {"name":"URL","newValue":"test.com"}]}

Are my JSON parameters correct?

If so -

API permissions on the App Registration is set to "Dataset.ReadWrite.All".

The pipeline succeeds, but no parameters are updated.

Please advise on next steps.

— Reply to this email directly, view it on GitHubhttps://github.com/maikvandergaag/msft-extensions/issues/550#issuecomment-2184977812, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ACIXAE6FWLRNA3XA7WT4VJDZI3AM5AVCNFSM6AAAAABI2QJND6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCOBUHE3TOOBRGI. You are receiving this because you were assigned.Message ID: @.***>

[sictransitoria]

Hi Maik,

Thanks for getting back to me.

I resolved the issue, so I removed the comment as it was a user error.

Quick question: Is it possible to set the refresh schedule and DataSource for multiple datasets at once or will that need to be a Feature Request?

[maikvandergaag]

That is a feature request