Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance 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 | |
5 | |
3 | |
2 | |
2 |
User | Count |
---|---|
9 | |
7 | |
5 | |
4 | |
4 |