Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
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
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
14 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
10 | |
3 | |
3 | |
3 | |
2 |