topic Re: Using Power Shell to update dataset parameter -Need help in Developer

Using Power Shell to update dataset parameter -Need help

roncruiser — Fri, 21 Mar 2025 22:45:30 GMT

Hi Everyone!
From the Power Shell command line interface, I run the commands below. No errors are thrown but the Power BI service dataset parameters in My Workspace do not change to the new values.
Can someone please review the script to see if I am missing something else? Maybe I am missing something.
Maybe adapt the script to try on your side and see if it runs for you.
There's documention online suggesting updating dataset parameters work.

I think maybe I am missing some access permissions to do this. I'm unsure.
Seeking help.

Thank you!
Note: Copilot suggested inserting this in place of the variable below:
$urlUpdateParams = "https://api.powerbi.com/v1.0/me/datasets/d62b1e0c-9060-4ecf-9994-ccd995d52693/parameters"
This doesnt work either.

$urlUpdateParams = "https://app.powerbi.com/groups/me/datasets/d62b1e0c-9060-4ecf-9994-ccd995d52693/parameters" $body = '{ "updateDetails": [ { "name": "DirectPath_NonOneDrive_JSON", "newValue": "\\new\source\folder\path" }, { "name": "Start Load Date_JSON", "newValue": "2025-02-10" }, { "name": "End Load Date_JSON", "newValue": "2025-03-30" } ] }' $content = 'application/json' Invoke-PowerBIRestMethod -Url $urlUpdateParams -Method Post -Body $body -ContentType $content

Re: Using Power Shell to update dataset parameter -Need help

Deku — Fri, 21 Mar 2025 23:35:31 GMT

URL should look like this

https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/Default.UpdateParameters

Docs here

Re: Using Power Shell to update dataset parameter -Need help

roncruiser — Sat, 22 Mar 2025 00:25:55 GMT

Thanks! I ran the scripit with the changes in the URL.

The errors suggest there is an issue with the last line of the script.
Two errors: One with AggregateException and the other with Exception.
Anyone know what could be the issue? -Seeking help
Thanks -

Invoke-PowerBIRestMethod -Url $urlUpdateParams -Method Post -Body $body -ContentType $content

Re: Using Power Shell to update dataset parameter -Need help

Deku — Sat, 22 Mar 2025 08:10:40 GMT

Update body like this

Please see this guyinacube video

Re: Using Power Shell to update dataset parameter -Need help

Anonymous — Tue, 06 May 2025 06:43:50 GMT

Hi @roncruiser ,
Thank you @Deku for the prompt response!

May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you.

Re: Using Power Shell to update dataset parameter -Need help

Anonymous — Thu, 15 May 2025 07:33:19 GMT

Hi @roncruiser ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

Re: Using Power Shell to update dataset parameter -Need help

Anonymous — Mon, 19 May 2025 10:49:34 GMT