Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Dom87326
Helper II
Helper II

Problems using Invoke-PowerBIRestMethod to update parameters

Hello community,

 

I’m working with multiple workspaces, reports and using powershell script that takes simple CSV file to determine what .pbix file goes into which workspace and what parameters to update (if any).

The script is really simple. It verifies if report name (full path has been received as a command line parameter) exists in the publisher.csv file. If exists then extract all values from a corresponding row (workspace name, dataset refresh request, parameter1 and parameter2 name, parameter1 value and parameter2 value) from the publisher.csv file (based on this blog).

 

To test the script, I'm using hardcoded $body and $url variables with Invoke-PowerBIRestMethod REST POST call:

 

 

#Group ID and Dataset ID 
$urlbase = "groups/4bc15b4f-5dc8-49e3-aaba-XXXXXXXXXXXX/datasets/AAAAAAAA-YYYY-4cb8-898a-222261a5e0d0/"

$body = '{
	updateDetails: [
    {
      "name": "%Date",
      "newValue": "11111111"
    },
    {
      "name": "%Customer",
      "newValue": "Amazon"
    }
   ]
}'

#url and body for UpdateParameters in API call
$url = $urlbase + "UpdateParameters"

Invoke-PowerBIRestMethod -Url $url -Method Post -Body $body -ContentType application/json

 

 


However I receive following error: 

 

 

Invoke-PowerBIRestMethod : One or more errors occurred.
At C:\Users\UserName\FolderPath\Publish one report.ps1:52 char:5
+     Invoke-PowerBIRestMethod -Url $url -Method Post -Body $body -Cont ...
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : WriteError: (Microsoft.Power...werBIRestMethod:InvokePowerBIRestMethod) [Invoke-PowerBIRestMethod], Aggregat 
   eException
    + FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod
 

 

 

 

Has anyone faced similar issues with this workflow? 

 

Many thanks in advance!

2 REPLIES 2
v-yiruan-msft
Community Support
Community Support

Hi  @Dom87326 ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yiruan-msft
Community Support
Community Support

Hi @Dom87326,

Are "%Date" and "%Customer" the actual paramater name? And the names were originally preceded by a prefix "%"? Is the date type of "%Date" Text type or Date type? Could you please refer the following thread to change the codes as below and check if it can work....

Update parameters through Powershell

#Group ID and Dataset ID 
$urlbase = "groups/4bc15b4f-5dc8-49e3-aaba-XXXXXXXXXXXX/datasets/AAAAAAAA-YYYY-4cb8-898a-222261a5e0d0/"

$body = '{
	updateDetails: [
    {
      "name": "%Date",
      "newValue": "11111111"
    },
    {
      "name": "%Customer",
      "newValue": "Amazon"
    }
   ]
}'

#url and body for UpdateParameters in API call
$url = $urlbase + "Default.UpdateParameters"

$content = 'application/json'

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

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.