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.
Hi,
As developer I'm well aware that we make mistakes or interpert the documentation a different way then intended but when you provide me with 400 status code and an exception message of "PowerBIEntityFrameworkOperationException".
Then you are doing something wrong because I'm not using EntityFramework so how can it be client error?? It should have been a 500 status code and even more important explain to me why it happens because PowerBIEntityFrameworkOperationException isn't telling me anything about how to solve my issue.
I'm calling:
POST https://api.powerbi.com/v1.0/myorg/gateways/67...../datasources
with
{
"dataSourceType": "Sql",
"connectionDetails": "{\"server\":\"server\\temp\",\"database\":\"AdventureWorksDW2017\"}",
"credentialDetails": {
"credentials": "tPo5......",
"credentialType": "Windows",
"encryptedConnection": "Encrypted",
"encryptionAlgorithm": "RSA-OAEP",
"privacyLevel": "Organizational",
"useCallerAADIdentity": false
},
"dataSourceName": "N3"
}
Note: creating the same gateway through https://app.powerbi.com works just fine so the gateway and the connection information are not incorrect.
And i get the very useful response on the request:
BadRequest with
{"error":{"code":"PowerBIEntityFrameworkOperationException","pbi.error":{"code":"PowerBIEntityFrameworkOperationException","parameters":{},"details":[]}}}
???
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.