I create Dataset in asp.net but error: The remote server returned an error: (403) Forbidden. Console is working.
public static string createDataset()
{
string rs = "";
HttpWebRequest request = null;
//string datasetJson = null;
//Push data into a Power BI dashboard
try
{
string powerBIDatasetsApiUrl = "https://api.powerbi.com/v1.0/myorg/datasets";
//POST web request to create a dataset.
//To create a Dataset in a group, use the Groups uri: https://api.PowerBI.com/v1.0/myorg/groups/{group_id}/datasets
request = System.Net.WebRequest.Create(powerBIDatasetsApiUrl) as System.Net.HttpWebRequest;
request.KeepAlive = true;
request.Method = "POST";
request.ContentType = "application/json";
if (String.IsNullOrEmpty(token))
{
rs = "token is null. " + "<br/>";
return rs;
}
//Add token to the request header
request.Headers.Add("Authorization", String.Format("Bearer {0}", token));
//Create dataset JSON for POST request
string datasetJson = "{\"name\": \"CorporationProduct\", \"tables\": " +
"[{\"name\": \"Product\", \"columns\": " +
"[{ \"name\": \"ProductID\", \"dataType\": \"Int64\"}, " +
"{ \"name\": \"Name\", \"dataType\": \"string\"}, " +
"{ \"name\": \"Category\", \"dataType\": \"string\"}," +
"{ \"name\": \"IsCompete\", \"dataType\": \"bool\"}," +
"{ \"name\": \"ManufacturedOn\", \"dataType\": \"DateTime\"}" +
"]}]}";
request.ContentLength = datasetJson.Length;
//POST web request
byte[] byteArray = System.Text.Encoding.UTF8.GetBytes(datasetJson);
request.ContentLength = byteArray.Length;
//Write JSON byte[] into a Stream
using (Stream writer = request.GetRequestStream())
{
writer.Write(byteArray, 0, byteArray.Length);
writer.Close();
var response = (HttpWebResponse)request.GetResponse(); // Error: The remote server returned an error: (403) Forbidden.
rs += string.Format("Dataset {0}", response.StatusCode.ToString()) + "<br/>";
rs += "createDataset operation is successfull." + "<br/>";
}
}
catch (Exception ex)
{
rs += "createDataset encounters an error: ";
rs += ex.Message;
}
return rs;
}
