topic Re: API with Powershell : Exporting report with bookmark in Developer

API with Powershell : Exporting report with bookmark

FXFelix — Tue, 25 Feb 2025 13:56:20 GMT

Hello community,

I can't figure how to make a Powershell API calls to export a report with bookmarks...

This piece of code :

$exportBody = @{ format = "PDF" powerBIReportConfiguration = @{ settings = @{ locale = "fr-FR" } } } | ConvertTo-Json -Depth 10 $response = Invoke-RestMethod -Method Post -Uri $url -Headers $headers -ContentType "application/json" -Proxy $proxyUri -ProxyUseDefaultCredentials -Body $exportBody

... is working.

But as soon as I try to add a specific page/bookmark, I get an error 400 Bad request :

$exportBody = @{ format = "PDF" powerBIReportConfiguration = @{ settings = @{ locale = "fr-FR" } pages = @(@{ pageName = "81438a987ba809f63572" bookmark = {name = "0bb3e333319e8ad6c06c"} }) } } | ConvertTo-Json -Depth 10 $response = Invoke-RestMethod -Method Post -Uri $url -Headers $headers -ContentType "application/json" -Proxy $proxyUri -ProxyUseDefaultCredentials -Body $exportBody

Any idea ?

Thanks in advance

Re: API with Powershell : Exporting report with bookmark

lbendlin — Tue, 25 Feb 2025 17:26:44 GMT

Try the same in the API sandbox. check the syntax there.

Re: API with Powershell : Exporting report with bookmark

FXFelix — Wed, 26 Feb 2025 11:03:23 GMT

I do not understand how it can help me : nothing about exporting a report, and anyway, nothing about the syntax of the API calls 🤔

Where can you see the syntax ?

Edit : I use that link : https://playground.powerbi.com/en-us/home

Re: API with Powershell : Exporting report with bookmark

FXFelix — Wed, 26 Feb 2025 14:33:32 GMT

$exportBody = @{ format = "PDF" powerBIReportConfiguration = @{ settings = @{ locale = "fr-FR" } pages = @(@{ pageName = "81438a987ba809f63572" bookmark = @{name = "0bb3e333319e8ad6c06c"} }) } } | ConvertTo-Json -Depth 10 $response = Invoke-RestMethod -Method Post -Uri $url -Headers $headers -ContentType "application/json" -Proxy $proxyUri -ProxyUseDefaultCredentials -Body $exportBody

But this code works 😃

There was a missing @ before the bookmark.