I am using "Imports - Create Temporary Upload Location In Group" to import pbix to workspace having premium capacity.
$uri = "https://api.powerbi.com/v1.0/myorg/groups/XXXXXXX/imports/createTemporaryUploadLocation"
$tulResponse =Invoke-RestMethod -Uri $uri –Headers $auth_header –Method POST
$tulResponse return url , expiration ,and odata.context successfully .
$temp_path ="local path of Pbix "
$httpClient = New-Object System.Net.Http.Httpclient $httpClientHandler
$HttpClient.DefaultRequestHeaders.Add("x-ms-blob-type", "BlockBlob");
$packageFileStream = New-Object System.IO.FileStream @($temp_path, [System.IO.FileMode]::Open)
$contentDispositionHeaderValue = New-Object System.Net.Http.Headers.ContentDispositionHeaderValue "form-data"
$contentDispositionHeaderValue.Name = "<< file name>>"
$contentDispositionHeaderValue.FileName = "<<filename.pbix>>"
$streamContent = New-Object System.Net.Http.StreamContent $packageFileStream
$streamContent.Headers.ContentDisposition = $contentDispositionHeaderValue
$content = New-Object System.Net.Http.MultipartFormDataContent
$content.Add($streamContent)
$response1 = $httpClient.PutAsync($tulResponse.url, $content).Result
response1 return s
----
Version : 1.1
Content : System.Net.Http.StreamContent
StatusCode : Created
ReasonPhrase : Created
Headers : {[x-ms-request-id, System.String[]], [x-ms-version, System.String[]], [x-ms-request-server-encrypted, System.String[]], [Date, System.String[]]...}
RequestMessage : Method: PUT, RequestUri: 'https://XXxxxxxxxxxx.blob.core.windows.net/xxxxxx/yyyyyyy/Import/zzzz?sv=2015-12-11&sr=b&sig=ccccccc...',
Version: 1.1, Content: System.Net.Http.MultipartFormDataContent, Headers:
{
x-ms-blob-type: BlockBlob
Content-Type: multipart/form-data; boundary="xxxxxxxxx"
Content-Length: 1091275
}
IsSuccessStatusCode : True
till then all are good
if($response1.IsSuccessStatusCode)
{
$bodypost = @{
'fileUrl' = $tulResponse.url
}
$uripost = "https://api.powerbi.com/v1.0/myorg/groups/xxxxx/imports?datasetDisplayName=<<filename>>&nameConflict..."
$respose2 =Invoke-RestMethod -Uri $uripost -Method POST -Body $bodypost -Headers $auth_header -ContentType 'multipart/form-data'
}
last line throw error
Invoke-RestMethod : {"error":{"code":"UnknownError","pbi.error":{"code":"UnknownError","parameters":{},"details":[],"exceptionCulprit":1}}}
Please help me out !! what I missed
Thanks in advance
Paritosh
