public async Task UpdateDatasetParameters(Guid groupId)
{
using (var client = await _pbiService.GetPowerBIClient())
{
var datasources = await client.Datasets.GetDatasetsInGroupAsync(groupId);
var dataSetId = datasources.Value.First().Id;
var gatewayresponse = await client.Datasets.GetDatasourcesInGroupAsync(groupId, dataSetId);
var gateway = gatewayresponse.Value.First();
// server and database name would most likely be passed in
// through the API in a real world scenario
var updateParametersList = new List <UpdateMashupParameterDetails>
{
{ new UpdateMashupParameterDetails {
Name = "servername", NewValue = _settings.DatabaseServerName
} },
{ new UpdateMashupParameterDetails {
Name = "databasename", NewValue = _settings.DatabaseName
} },
};
var paramRequest = new UpdateMashupParametersRequest(updateParametersList);
await client.Datasets.UpdateParametersInGroupAsync(groupId, dataSetId, paramRequest);
}
return;
}
public static void UpdateParameter(Guid WorkspaceId, string DatasetId, string ParameterName, string ParameterValue)
{
PowerBIClient pbiClient = TokenManager.GetPowerBiClient(requiredScopes);
IList <Dataset> datasets = pbiClient.Datasets.GetDatasetsInGroup(WorkspaceId).Value;
var dataset = datasets.Where(ds => ds.Id.Equals(DatasetId)).Single();
Console.WriteLine(dataset.Name);
Console.WriteLine();
UpdateMashupParametersRequest req =
new UpdateMashupParametersRequest(
new UpdateMashupParameterDetails {
Name = ParameterName,
NewValue = ParameterValue
});
pbiClient.Datasets.UpdateParametersInGroup(WorkspaceId, DatasetId, req);
}
