The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all!
I've been trying to create a dataset pointing to Azure Analysis Services via the REST API's:
Push Datasets - Datasets PostDatasetInGroup
{
"name": "ApiTestAasDataset",
"isRefreshable": false,
"isEffectiveIdentityRequired": true,
"isEffectiveIdentityRolesRequired": false,
"isOnPremGatewayRequired": false,
"datasources": [
{
"datasourceType": "AnalysisServices",
"connectionDetails": {
"server": "asazure://westeurope.asazure.windows.net/testanalysisalf:rw",
"database": "alf"
},
"connectionString": "Provider=MSOLAP;Data Source=asazure://westeurope.asazure.windows.net/testanalysisalf;Initial Catalog=alf;Cube=Model;User ID=myname@mydomain.com;Persist Security Info=True;Impersonation Level=Impersonate"
}
],
"tables": []
"defaultMode": "AsAzure"
}
The response it's always 400:
{ "error": { "code": "FailedToDeserializeDatasetError", "pbi.error": { "code": "FailedToDeserializeDatasetError", "parameters": {}, "details": [], "exceptionCulprit": 1 } } }
Any sugestions?
Thank you very much and best regards,
Alfredo
User | Count |
---|---|
5 | |
2 | |
2 | |
2 | |
2 |
User | Count |
---|---|
11 | |
7 | |
5 | |
4 | |
4 |