topic Re: Import Dataflow in Power BI Service in Developer

Import Dataflow in Power BI Service

Anonymous — Tue, 13 Sep 2022 13:36:40 GMT

I use this script to import a dataflow :

$credential = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList "...", ("..." | ConvertTo-SecureString -AsPlainText -Force) Connect-PowerBIServiceAccount -ServicePrincipal -Tenant "..." -Credential $credential -Environment "Public" $workspaceName = "WKS - DTS [DEV]" $DataflowImportFileName = "C:\Users\cbonier\Documents\DTF FINANCE.json" $DataflowDefinition = [IO.File]::ReadAllText($DataflowImportFileName) $UserAccessToken = Get-PowerBIAccessToken $bearer = $UserAccessToken.Authorization.ToString() $workspace = Get-PowerBIWorkspace -Name $workspaceName $workspaceId = $workspace.Id $importsUrl = "https://api.powerbi.com/v1.0/myorg/groups/$workspaceId/imports?datasetDisplayName=DTF FINANCE.json" $boundary = [System.Guid]::NewGuid().ToString("N") $LF = [System.Environment]::NewLine $contentType = "multipart/from-data; boundary=""$boundary""" $body = ( "--$boundary", "Content-Disposition: form-data $LF", $DataflowDefinition, "--$boundary--$LF" ) -join $LF $header = @{ 'Authorization' = "$bearer" 'Content-Type' = "$contentType" } Invoke-RestMethod -Uri $importsUrl -ContentType $contentType -Method Post -Headers $header -Body $body

But I have this error :

Re: Import Dataflow in Power BI Service

v-chenwuz-msft — Wed, 14 Sep 2022 07:05:01 GMT

Hi @Anonymous ,

POST https://api.powerbi.com/v1.0/myorg/groups/cfafbeb1-8037-4d0c-896e-a46fb27ff229/imports?datasetDisplayName=model.json&nameConflict=Abort&skipReport=True

This parameter should be hardcoded to model.json.

For more details, you can refer this link.

Imports - Post Import In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

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

Re: Import Dataflow in Power BI Service

Anonymous — Wed, 14 Sep 2022 07:13:37 GMT

Hi @v-chenwuz-msft,

What do you mean when you write : "This parameter should be hardcoded to model.json." ?

I tried this script but it doesn't work :

Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/groups/cfafbeb1-8037-4d0c-896e-a46fb27ff229/imports?datasetDisplayName=model.json&nameConflict=Abort&skipReport=True" -Method Post

Error message :

AVERTISSEMENT : The Body parameter was null, the request may be invalid when Method par ameter is Post. Invoke-PowerBIRestMethod : Une ou plusieurs erreurs se sont produites. Au caractère Ligne:5 : 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