Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I am trying to create a dataset, pointing to an Azure AS model, in Power BI using the REST APIs. I get get the following error:
FailedToDeserializeDatasetError
I can successfully create datasets not pointing to an Azure AS model.
I use the following post body:
{
"name":"MyTestDataset",
"defaultMode":"AzureAS",
"tables": [],
"datasources":[
{
"name":"dataSource1",
"connectionString":"Data Source=asazure://northeurope.asazure.windows.net/myazureas;Initial Catalog=mydatabase;Cube=Model"
}
]
}
Anyone got this working?
Solved! Go to Solution.
The documentation is not correct related to AAS: https://msdn.microsoft.com/en-us/library/mt203562.aspx
It also should be 'defaultMode':'AsOnPrem' for the Azure Analysis Service instead of AzureAS:
{'name':'AAS','defaultMode':'AsOnPrem','tables':[],'datasources':[{'name':'AAS','connectionString':''}]}
-JP
error for me , getting 202 instead of 201 for dataset creation.
this is something wrong with the conenction string for postgres.
as it very difficult to understand and findout exactly what needs to be the structure for a postgres datasource.
i have tried various patterns for the connection string with no luck.
"datasources":[
{
"name":"postgres",
"connectionString":"Provider=ODBC;Data Source=postgresql://localhost/postgres?user=postgres&password=12345&ssl=prefer;Initial Catalog = postgres; Cube=Model;"
}
]
"datasources":[
{
"name":"postgres",
"connectionString":"Server=localhost;Port=5432;Database=postgres;User Id=postgres;Password=root;"
}
]
}
datasources":[
{
"name":"postgres",
"connectionString":"Data Source=postgresql://localhost/Postgres?user=other&password=secret;Initial Catalog=Postgres;Cube=Model"
OR
Data Source=jdbcostgresql://localhost/Postgres?user=fred&password=secret&ssl=true
}
]
Also, the terms CUBE and INITIAL CATALOG, PROVIDER these keys have very less info available on the net for postgres connection string. A detailed explanation for postgres connection string would be helpful here.
The documentation is not correct related to AAS: https://msdn.microsoft.com/en-us/library/mt203562.aspx
It also should be 'defaultMode':'AsOnPrem' for the Azure Analysis Service instead of AzureAS:
{'name':'AAS','defaultMode':'AsOnPrem','tables':[],'datasources':[{'name':'AAS','connectionString':''}]}
-JP
Works perfect, thanks!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
6 | |
2 | |
2 | |
2 |
User | Count |
---|---|
4 | |
4 | |
4 | |
4 | |
4 |