Patching an Online DirectQuery datasource

Can you please elaborate on what values should be provided for gatewayId and datasourceId? v-ljerr-msft responded with the same block of code in my request (https://community.powerbi.com/t5/Developer/How-to-update-credentials-of-a-connection-with-V2-API-in-package/m-p/344260#M10205) but I think you guys are only providing half the answer here.

My datasource is Azure SQL (*NOT* Analysis Services), but I'd also like this to work for Azure Table Storage.

I can use the Microsoft.PowerBI.Api.V2 classes to:

1. Enumerate my groups to find the group id I want by name via IPowerBIClient.Groups.GetGroupsAsync
2. Enumerate the reports in the group to find the id of the report by name via IPowerBIClient.Reports.GetReportsInGroupAsync
3. Each of these reports has a DataSetId, ok great, maybe that provides the gateway/datasourceId.
4. I get the Dataset via IPowerBIClient.Datasets.GetDatasetByIdInGroupAsync

The Dataset object has a Datasources property. However this is NULL. So I find myself at a dead end!

A few other frustrations...

• Calling IPowerBIClient.Datasets.GetDatasetsAsync returns an empty list. What the? Surely this should at least return the dataset that is returned by #4 above, plus any other datasets in any other reports in any other groups, i.e. all datasets accessible to the authenticated user.
• Your samples keep talking about a gatewayId, ok then lets call IPowerBIClient.Gateways.GetGatewaysAsync... and I get nothing back (which makes sense, since I don't have any on-prem gateways running/configured, but your samples keep referring to gatewayId - which makes me think we are talking at cross-purposes re datasets using on-prem gateways vs cloud datasources).

What should be the values for gatewayId and datasourceId?

If you are providing the credentials for an Azure SQL or Azure Table Storage datasource, these things do not require an on-premise gateway to access.

The V2 API (at least via Nuget) does not return any datasource objects when you request a dataset - therefore no datasource id can be provided.

Gateways.GetGateways (or whatever it is called) returns nothing... as I have no on-prem gateways!