cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alfdagos Frequent Visitor
Frequent Visitor

Re: Problems on creating a new dataset with Power BI's REST API

Thanks a lot @eligr!

 

Suppose once I've created the dataset with PowerBI Desktop, I want to duplicate and modify it to point to other tables of the same database or same HDInsight instance (naturally with the same schema..). Can you explain me the correct steps to do with the Rest API if it's possible?

 

Thank you very much for the fast replay!

 

Best regards,

    Alfredo.

tpaz Visitor
Visitor

Re: Problems on creating a new dataset with Power BI's REST API

@eligr, could you please provide an example about how to create a dataset to Analysis Services?

 

I got the same "FailedToParseConnectionStringError" error.

 

I tried many combinations of properties and different connection string formats.

This is my request:

 

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets

 

 

{
  "name": "ApiTestAasDataset1",
  "isRefreshable": false,
  "isEffectiveIdentityRequired": true,
  "isEffectiveIdentityRolesRequired": false,
  "isOnPremGatewayRequired": false,
  "datasources": [
  	{
      "datasourceType": "AnalysisServices",
      "connectionDetails": {
        "server": "asazure://australiasoutheast.asazure.windows.net/myserver:rw",
        "database": "mydb"
      },
      "connectionString": "Provider=MSOLAP;Data Source=asazure://australiasoutheast.asazure.windows.net/myserver;Initial Catalog=mydb;User ID=myuser@mydomain.com.au;Password=mypassword;Persist Security Info=True;Impersonation Level=Impersonate"
  	}
  	],
  "defaultMode": "AsAzure"
}

 

gowra1v Occasional Visitor
Occasional Visitor

Re: Problems on creating a new dataset with Power BI's REST API

Is it possible to create datasets with Datasource type File using Power BI API? If possible what metadata information we need to feed in request body

arnoc Frequent Visitor
Frequent Visitor

Re: Problems on creating a new dataset with Power BI's REST API

I've been struggling with this as well. I also tried your request, adding 'Cube=Model' to your connectionstring gets you (or at least me with your request body) to the point where I'm stuck - receiving 401 errors...

 

I've create separate thread for this issue here that will hopefully see us resolve both our problems.

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 133 members 1,883 guests
Please welcome our newest community members: