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:
$body2='{
"dataSourceType": "Sql",
"connectionDetails": "{\"server\":\"Server\",\"database\":\"TEST_DB\"}",
"datasourceName": "Sample",
"credentialDetails": {
"credentialType": "Basic",
"credentials": "{\"credentialData\":[{\"name\":\"username\", \"value\":\"ABC\"},{\"name\":\"password\", \"value\":\"ABC\"}]}",
"encryptedConnection":"Encrypted",
"encryptionAlgorithm":"RSA-OAEP",
"privacyLevel":"None"
}
}'
Invoke-PowerBIRestMethod -url "https://api.powerbi.com/v1.0/myorg/gateways/$gatewayID/datasources" -Method post -body $body2
$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!
Any Help?
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 |
---|---|
16 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
29 | |
3 | |
3 | |
2 | |
2 |