Option #7 gives an error

[julianmbs]

Hi,

When I try to update data source credentials (option #7), I get an error "Index was out of range. Must be non-negative and less than the size of the collection". When I debug it, I see that line 544 (client.Datasets.GetGatewayDatasourcesAsync) returns NULL to datasources variable, even though all the parameters are set correctly (workspaceCollectionName, workspaceId, and datasetKey). What could be the problem?

Thanks,
Julia

[wbreza]

Is your dataset a DirectQuery dataset? Updating credentials is only supported on a direct query datasets.

[julianmbs]

Some of my datasets are DirectQuery and some are not, I would like to update the ones that are. Looks like the code takes the ID of the last dataset?

datasets.Value[datasets.Value.Count - 1].Id

Is that the problem?

[julianmbs]

I changed the code to make sure it takes the ID of the dataset that is DirectQuery for sure, but I am still getting NULL:

var datasources = await client.Datasets.GetGatewayDatasourcesAsync(workspaceCollectionName, workspaceId, datasets.Value[0].Id);

Any other ideas?

[wbreza]

Yes - you are correct. This sample only illustrates updating the last dataset. Feel free to augment to fit your needs.

We also have a more feature rich cross platform CLI tool that has better support than this sample. Check it out @ https://github.com/Microsoft/PowerBI-Cli.