@insoluzioni wrote:
Hello,
I am trying to automatically import a PBIX file into my workspace with Power BI Embedded, currently using the code below, but I get the error:
HTTP Error 400. The request is badly formed.
I really couldn't find the correct syntax to send it via PHP cURL, currently using this:
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "https://api.powerbi.com/v1.0/collections/$workspace_collection_name/workspaces/$workspace_id/imports?datasetDisplayName=$display_name&nameConflict=$nameConflict");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
curl_setopt($ch, CURLOPT_HEADER, FALSE);
curl_setopt($ch, CURLOPT_POST, TRUE);
$boundary = "BOUNDARY";
$postdata = "--". $boundary . "\r\n";
$postdata .= "Content-Disposition: form-data;\r\n";
$postdata .= "\r\n";
$postdata .= "{".file_get_contents($file_path)."}";
$postdata .= "--".$boundary . "--\r\n";
curl_setopt($ch, CURLOPT_POSTFIELDS, $postdata);
curl_setopt($ch, CURLOPT_HTTPHEADER, array(
"Authorization: AppKey $access_key",
"Content-Type: multipart/form-data; boundary=$boundary"
));
$response = curl_exec($ch);
curl_close($ch);
var_dump($response);
Anyone would spot what I am doing wrong?
Thanks
@insoluzioni
The error shows nothing on PHP specific I think, it tells that there's something wrong in the request. I don't know PHP, however below C# demo can compose a good request and import a pbix to my workspace. You can reference the demo and tweak the request in PHP accordingly.
using System;
using System.Net;
using System.IO;
namespace PBIGettingStarted
{
class Program
{
//Access key for app token
private static string accessKey = "yourAccesskey";
//Power BI app token values
private static string workspaceCollectionName = "yourworkspacecollectioname";
private static string workspaceId = "yourworkspaceid";
private static string pbixFileName = "pbixname.pbix";
static void Main(string[] args)
{
//Imports uri
var uri = String.Format
("https://api.powerbi.com/v1.0/collections/{0}/workspaces/{1}/imports?datasetDisplayName=SampleImport",
workspaceCollectionName, workspaceId);
//PBIX file to import
string fileName = @"C:\test\kpi.pbix";
//Create web request
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(uri);
//Import Request format:
// Header:
// Content - Type: multipart / form - data; ----------BOUNDARY
// Authorization: AppToken
// Body:
// ----------BOUNDARY
// Content - Disposition: form - data; filename = "{pbix file}.pbix"
// Content - Type: application / octet – stream
//Define POST
request.Method = "POST";
request.UseDefaultCredentials = true;
//Header
// Boundary
string boundary = "----------BOUNDARY";
byte[] boundaryBytes = System.Text.Encoding.ASCII.GetBytes("\r\n--" + boundary + "\r\n");
// Content - Type
request.ContentType = "multipart/form-data; boundary=" + boundary;
// Authorization - Use AppToken jwt for Authorization header
request.Headers.Add("Authorization", String.Format("AppKey {0}", accessKey));
//Body
string bodyTemplate = "Content-Disposition: form-data; filename=\"{0}\"\r\nContent-Type: application / octet - stream\r\n\r\n";
string body = string.Format(bodyTemplate, fileName);
byte[] bodyBytes = System.Text.Encoding.UTF8.GetBytes(body);
//Get request stream
using (Stream rs = request.GetRequestStream())
{
rs.Write(boundaryBytes, 0, boundaryBytes.Length);
rs.Write(bodyBytes, 0, bodyBytes.Length);
using (FileStream fileStream = new FileStream(fileName, FileMode.Open, FileAccess.Read))
{
byte[] buffer = new byte[4096];
int bytesRead = 0;
while ((bytesRead = fileStream.Read(buffer, 0, buffer.Length)) != 0)
{
rs.Write(buffer, 0, bytesRead);
}
}
byte[] trailer = System.Text.Encoding.ASCII.GetBytes("\r\n--" + boundary + "--\r\n");
rs.Write(trailer, 0, trailer.Length);
}
//Get response
using (HttpWebResponse response = request.GetResponse() as System.Net.HttpWebResponse)
{
//If Import succeeds, StatusCode = Accepted
var responseStatusCode = response.StatusCode.ToString();
}
}
}
}
