Hello,
I am trying to create a Dataset using Power BI API.
As Datasource I want to chose the OData Query from Business Central.
However, OData requires credentials, and I am not sure where I can provide them.
I am using the code from "Embed for Customers" example and Service Principal as authentication method.
Will provide some of the code below (some lines are commented out since I am experimenting):
public async Task AddDatasetAsync(Guid workspaceId, AddDatasetDto datasetDto)
{
using (var pbiClient = await GetPowerBiClient())
{
var request = new CreateDatasetRequest
{
Datasources = new List<Datasource>
{
new Datasource
{
//ConnectionDetails = new DatasourceConnectionDetails(),
//ConnectionString = datasetDto.ConnectionString,
DatasourceType = "OData",
Name = "Dynamics365BusinessCentral",
ConnectionDetails = new DatasourceConnectionDetails
{
//Database = datasetDto.Database,
//Server = datasetDto.Server,
Url = datasetDto.Url
}
}
},
//DefaultMode = DatasetMode.Streaming,
Name = datasetDto.DatasetName,
Tables = new List<Table>()
//Tables = new List<Table>
//{
// new Table
// {
// Source = new List<ASMashupExpression>
// {
// new ASMashupExpression
// {
// Expression = ""
// }
// }
// }
//}
};
await pbiClient.Datasets.PostDatasetInGroupAsync(workspaceId, request);
}
}
The client itself is:
public async Task<PowerBIClient> GetPowerBiClient()
{
var tokenCredentials = new TokenCredentials(await aadService.GetAccessToken(), "Bearer");
return new PowerBIClient(new Uri(urlPowerBiServiceApiRoot), tokenCredentials);
}
I am trying to post a Dataset by providing "Url" property, in which I put OData query link.
However, every time I try to post a Dataset I get "BadRequest" error.
Clearly I do not specify credentials (it's using Basic Auth - Web Access Key).
Could you help with this issue?
