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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Ybam
Helper I
Helper I

PowerShell Invoke-PowerBIRestMethod -Method Post WriteError

Hi, 

I have a PowerShell script for Rebind my report in a workspace. 

 

$clientId = "myClientId"
$clientSec = "myClientSecret" | ConvertTo-SecureString -AsPlainText -Force
$tenantId = "myTenantId"

$credential = New-Object System.Management.Automation.PSCredential($clientId$clientSec)
Connect-PowerBIServiceAccount -ServicePrincipal -Credential $credential -TenantId $tenantId


$Workspace = Get-PowerBIWorkspace -Name WorkspaceName
$WorkspaceId = $Workspace.Id
write-host $WorkspaceId
$report = Get-PowerBIReport -WorkspaceId $WorkspaceId -Name ReportName
$reportId = $report.ID
write-host $reportId
$dataset = Get-PowerBIDataset -WorkspaceId $WorkspaceId
$datasetId = $dataset.ID
write-host $datasetId


# Get token
$token =  Get-PowerBIAccessToken -AsString
write-host $token

# Building Rest API header with authorization token
$authHeader = @{
   "Authorization"$token
   "Content-Type" = "application/json"
}

# POST body 
$postParams = @{
    "datasetId" = "$datasetId"
}

$jsonPostBody = $postParams | ConvertTo-JSON

# Rebing reports 
Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/groups/$($WorkspaceId)/reports/&($reportId)/Rebind" -Method Post -Headers $authHeader -Body $jsonPostBody  -Verbose

 

When I run that I get this error:

"Invoke-PowerBIRestMethod : Une ou plusieurs erreurs se sont produites.
Au caractère path\Desktop\TestRebind.ps1:38 : 1
+ Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/gro ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...werBIRestMethod:InvokePowerBIRestMethod) [Invoke-PowerBIRestMethod], AggregateException
+ FullyQualifiedErrorId : Une ou plusieurs erreurs se sont produites.,Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod"

 

My token looks like : "Bearer *********"

My API permissions are Read and Write ALL except for Tenant because I am not admin

 

Someone can help me please ? 

1 ACCEPTED SOLUTION

Hi @v-lionel-msft , 

Yes I'm sure I have these permissions. 

My error was fixed. 

My problem was the "Headers" parameter of my invoke method. 

I didn't need the token since I was already logged in.

View solution in original post

3 REPLIES 3
v-lionel-msft
Community Support
Community Support

Hi @Ybam ,

 

thank you for your sharing.

 

Best regards,
Lionel Chen

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

v-lionel-msft
Community Support
Community Support

Hi @Ybam ,

 

Do you really have these two permissions?

v-lionel-msft_0-1606973007675.png

 

Best regards,
Lionel Chen

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

 

Hi @v-lionel-msft , 

Yes I'm sure I have these permissions. 

My error was fixed. 

My problem was the "Headers" parameter of my invoke method. 

I didn't need the token since I was already logged in.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors