public static async Task PatchSqlDatasourceCredentials(string WorkspaceId, string importName) { PowerBIClient pbiClient = GetPowerBiClient(); var datasets = (await pbiClient.Datasets.GetDatasetsInGroupAsync(WorkspaceId)).Value; foreach (var dataset in datasets) { if (importName.Equals(dataset.Name)) { string datasetId = dataset.Id; var datasources = (await pbiClient.Datasets.GetDatasourcesInGroupAsync(WorkspaceId, datasetId)).Value; foreach (var datasource in datasources) { if (datasource.DatasourceType == "SQL") { var datasourceId = datasource.DatasourceId; var gatewayId = datasource.GatewayId; // create credentials for Azure SQL database log in Creds.BasicCredentials creds = new Creds.BasicCredentials("CptStudent", "pass@word1"); CredentialDetails details = new CredentialDetails(creds); UpdateDatasourceRequest req = new UpdateDatasourceRequest(details); // Update credentials through gateway await pbiClient.Gateways.UpdateDatasourceAsync(gatewayId, datasourceId, details); } } } } return; }
public void Cloud_BasicCredentialsTest() { CredentialsBase credentials = new BasicCredentials("user", "pass"); var credentialDetails = new CredentialDetails(credentials, PrivacyLevel.None, EncryptedConnection.Encrypted); Assert.IsNotNull(credentialDetails); Assert.AreEqual("{\"credentialData\":[{\"name\":\"username\",\"value\":\"user\"},{\"name\":\"password\",\"value\":\"pass\"}]}", credentialDetails.Credentials); Assert.AreEqual(CredentialType.Basic, credentialDetails.CredentialType); Assert.AreEqual(EncryptedConnection.Encrypted, credentialDetails.EncryptedConnection); Assert.AreEqual(EncryptionAlgorithm.None, credentialDetails.EncryptionAlgorithm); Assert.AreEqual(PrivacyLevel.None, credentialDetails.PrivacyLevel); Assert.AreEqual(false, credentialDetails.UseCallerAADIdentity); }
public void OnPrem_BasicCredentialsTest() { CredentialsBase credentials = new BasicCredentials("user", "pass"); var credentialsEncryptor = new AsymmetricKeyEncryptor(publicKey); var credentialDetails = new CredentialDetails(credentials, PrivacyLevel.None, EncryptedConnection.Encrypted, credentialsEncryptor); Assert.IsNotNull(credentialDetails); Assert.IsNotNull(credentialDetails.Credentials); Assert.AreEqual(CredentialType.Basic, credentialDetails.CredentialType); Assert.AreEqual(EncryptedConnection.Encrypted, credentialDetails.EncryptedConnection); Assert.AreEqual(EncryptionAlgorithm.RSAOAEP, credentialDetails.EncryptionAlgorithm); Assert.AreEqual(PrivacyLevel.None, credentialDetails.PrivacyLevel); Assert.AreEqual(false, credentialDetails.UseCallerAADIdentity); }