Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello Team,
SQL server Data base is a managed DB and login credentials are not provided, rather connection is being established using AD-ENT login and IAM password,
Looking forward for a way to see how AD-ENT login and IAM password can be used to make a connection from Power BI to MS SQL server.
Also looking for options for connecting to PowerBI using JDBC connect string,
Thanks in advance!
Solved! Go to Solution.
Hi, @Anonymous
To connect from Power BI to MS SQL server using AD-ENT login and IAM password, you need to use the Microsoft ODBC Driver 13 or later. This driver supports Azure Active Directory (AAD) authentication, which is required for AD-ENT login and IAM password.
Here are the steps to follow:
You can also use a JDBC connection string to connect from Power BI to MS SQL server2, but you need to make sure the Data Connectivity mode is set to Import.
Connect from Power BI to Azure SQL Database using AAD authentication - Microsoft Community Hub
Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Learn
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
To rotate a key every 60 days in an Azure Function app using PowerShell, you can use the following script as an example:
```powershell
param($Timer)
$KeyVaultName = "
$SecretName = "
$RotationDays = 60
$currentDateTime = Get-Date
$keyRotationDateTime = Get-AzureKeyVaultSecret -VaultName $KeyVaultName -Name $SecretName | Select-Object -ExpandProperty Attributes | Select-Object -ExpandProperty Updated
# Convert the last rotation date to a DateTime object
$lastRotationDateTime = [DateTime]::Parse($keyRotationDateTime)
$daysSinceRotation = ($currentDateTime - $lastRotationDateTime). Days
if ($daysSinceRotation -ge $RotationDays) {
# Generate a new key value
$newKeyValue = New-Guid
# Update the key value in Azure Key Vault
Set-AzureKeyVaultSecret -VaultName $KeyVaultName -Name $SecretName -SecretValue $newKeyValue
Write-Host "Key has been rotated successfully."
} else {
Write-Host "No action required."
}
```
Ensure you have configured your Function app with a Timer trigger that triggers the script periodically. Adjust the values of `$KeyVaultName` and `$SecretName` with the appropriate names for your Key Vault and Secret.
The script checks the number of days that have passed since the last key rotation. If it exceeds the specified rotation period (60 days in this example), a new key is generated and updated in the Azure Key Vault. Otherwise, the script outputs that no action is required.
Remember to publish and configure your Azure Function app with the appropriate settings according to your requirements.
Hi, @Anonymous
To connect from Power BI to MS SQL server using AD-ENT login and IAM password, you need to use the Microsoft ODBC Driver 13 or later. This driver supports Azure Active Directory (AAD) authentication, which is required for AD-ENT login and IAM password.
Here are the steps to follow:
You can also use a JDBC connection string to connect from Power BI to MS SQL server2, but you need to make sure the Data Connectivity mode is set to Import.
Connect from Power BI to Azure SQL Database using AAD authentication - Microsoft Community Hub
Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Learn
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
85 | |
84 | |
73 | |
49 |
User | Count |
---|---|
142 | |
133 | |
110 | |
68 | |
55 |