Hello,
In effort to automate the creating of data source on a given Gateway, I have started using the PowerBI REST API commands.
I'm currently trying to create a sample data source on a specific gateway ID using the post command from PowerShell.
I went over the documentation and believe i have all the parameters correct. However, when i try to post i get the the following error:
+ CategoryInfo : WriteError: (Microsoft.Power...werBIRestMethod:InvokePowerBIRestMethod) [Invoke-PowerBIRestMethod], AggregateException
+ FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod
Here's my code:
Invoke-PowerBIRestMethod -url "https://api.powerbi.com/v1.0/myorg/gateways/{$gatewayID}/datasources" -Method POST -body $json_body
$json_body:
PS C:\windows\system32> $json_body
{
"encryptedConnection": "Encrypted",
"connectionDetails": "{\"server\":\"servername\",\"database\":\"dbname\"}",
"datasourceName": "Sample",
"credentialDetails": "{",
"credentialType": "Windows",
"dataSourceType": "SQL Server",
"encryptionAlgorithm": "RSA-OAEP",
"credentials": "domain\\user",
"privacyLevel": "Organizational"
}
$GatewayID is defined. the Get method does work and I can see all of the data source on that Gateway, but the POST just fails.
I have tried so many things and get the same error.
Any help would be apprieciated!
