Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
@v-shex-msft is it possible to get an actual example of how to post a new data source on a specific gatewau besides the info from
https://docs.microsoft.com/en-us/rest/api/power-bi/gateways/createdatasource ?
it's unclear which params are requires and how to put them...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |