Unable to create Dataset using PostDatasetInGroup API

Anonymous — Wed, 02 Mar 2022 07:52:51 GMT

When I tried to create dataset using the following request. It is giving bad request error. What is wrong with this request and how can I make it work.

var client = GetPowerBIClient();
var datasets = client.Datasets;
var table = new Table
{
Name = "Sample",
Columns = new List<Column>
{
new Column
{
Name = "Name",
DataType = "string"
},
new Column
{
Name = "Id",
DataType = "Int64"
},
new Column
{
Name = "Type",
DataType = "string"
}
}
};

var request = new CreateDatasetRequest();
request.Name = "SampleDataSet";
request.Tables = new List<Table> { table };
var gateway = client.Gateways.GetGateways().Value.FirstOrDefault();
var credentials = new BasicCredentials("Username", "Password");
var credentialsEncryptor = new AsymmetricKeyEncryptor(gateway.PublicKey);
var credentialDetails = new CredentialDetails(credentials, PrivacyLevel.Private, EncryptedConnection.Encrypted, credentialsEncryptor);
var datasource = client.Gateways.GetDatasources(gateway.Id).Value.FirstOrDefault(d => d.DatasourceName == "Sample1");
request.Datasources = new List<Datasource>
{
new Datasource
{
Name = datasource.DatasourceName,
ConnectionDetails = new DatasourceConnectionDetails
{
Database = "databasename",
Server = "servername"
},
DatasourceType = "Sql",
DatasourceId = datasource.Id,
GatewayId = gateway.Id,
ConnectionString = "Server=servername;Database=databasename;User ID=userId;Password=Password;"

}
};

var response = datasets.PostDatasetInGroup(new Guid("xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxx"), request);

Re: Unable to create Dataset using PostDatasetInGroup API

Anonymous — Mon, 07 Mar 2022 02:11:14 GMT

HI @Anonymous,

According to the error message, it seems like they are something wrong with your HTTP request.

For this scenario, I'd like to suggest you take a look at the official document and push your dataset with the corresponding JSON format:

Push Datasets - Datasets PostDatasetInGroup - REST API (Power BI Power BI REST APIs) | Microsoft Docs

400 Bad Request - HTTP | MDN (mozilla.org)
Regards,

Xiaoxin Sheng

topic Unable to create Dataset using PostDatasetInGroup API in Developer

Unable to create Dataset using PostDatasetInGroup API

Re: Unable to create Dataset using PostDatasetInGroup API