Forum Discussion

GunterM's avatar
GunterM
Regular Visitor
8 years ago
Solved

Patching an Online DirectQuery datasource

Hi,   I can execute a patch request to set the credentials of a online directquery datasource using the HttpClient class with no problem. But now I'm looking for a way to do this using the classes ...
Need Help
  • eligr's avatar
    eligr
    8 years ago

    Hi!

     

    use:

    m_client.Gateways.UpdateDatasource(<gatewayId>, <datasourceId>, <request>);

     

    where request is

    - request {Microsoft.PowerBI.Api.V2.Models.UpdateDatasourceRequest} Microsoft.PowerBI.Api.V2.Models.UpdateDatasourceRequest
    - CredentialDetails {Microsoft.PowerBI.Api.V2.Models.CredentialDetails} Microsoft.PowerBI.Api.V2.Models.CredentialDetails
    CredentialType "Basic" string
    Credentials "{\"credentialData\":[{\"name\":\"username\",\"value\":\"<username>\"},{\"name\":\"password\",\"value\":\"<password>"}]}" string
    EncryptedConnection "Encrypted" string
    EncryptionAlgorithm "None" string
    PrivacyLevel "None" string

     

    Eli.

eligr's avatar
eligr
Icon for Power BI Team rankPower BI Team
8 years ago

Hi!

 

use:

m_client.Gateways.UpdateDatasource(<gatewayId>, <datasourceId>, <request>);

 

where request is

- request {Microsoft.PowerBI.Api.V2.Models.UpdateDatasourceRequest} Microsoft.PowerBI.Api.V2.Models.UpdateDatasourceRequest
- CredentialDetails {Microsoft.PowerBI.Api.V2.Models.CredentialDetails} Microsoft.PowerBI.Api.V2.Models.CredentialDetails
CredentialType "Basic" string
Credentials "{\"credentialData\":[{\"name\":\"username\",\"value\":\"<username>\"},{\"name\":\"password\",\"value\":\"<password>"}]}" string
EncryptedConnection "Encrypted" string
EncryptionAlgorithm "None" string
PrivacyLevel "None" string

 

Eli.

jimmcslim's avatar
jimmcslim
Icon for Helper III rankHelper III
8 years ago

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!

  • eligr's avatar
    eligr
    Icon for Power BI Team rankPower BI Team
    8 years ago

    Hi.

    For cloud data sources, there is a default gateway created by Power BI.

    To find out the gateway and datasource ids, use this call: GetBoundGatewayDatasources (https://msdn.microsoft.com/en-us/library/mt732874.aspx)

    The SDK equivalent are Datasets.GetGatewayDatasources or Datasets.GetGatewayDatasourcesInGroup

     

    Eli.