Forum Discussion

saranrajk's avatar
saranrajk
Helper II
6 years ago

how to get data from shared dataset inside folder using power BI rest API?

Hi,

I'm trying to get data from a dataset inside folder using rest API.

http://d2n3kzl2//reports/api/v2.0/folders(dataset id)/catalogitems

By using the above url I getting the following items

{
  "@odata.context":"http://<server name>/reports/api/v2.0/$metadata#CatalogItems","value":[
    {
      "@odata.type":"#Model.DataSet","Id":"dataset ID","Name":"forGinieDataset","Description":null,"Path":"/forGinie/forGinieDataset","Type":"DataSet","Hidden":false,"Size":3000,"ModifiedBy":"D2N3KZL2\\GainAdmin","ModifiedDate":"2019-12-02T13:41:54.82+05:30","CreatedBy":"D2N3KZL2\\GainAdmin","CreatedDate":"2019-12-02T12:30:13.137+05:30","ParentFolderId":"217f25cd-4770-4e4f-a870-64e514d44d7f","IsFavorite":false,"Roles":[
        
      ],"ContentType":null,"Content":"","HasParameters":false,"QueryExecutionTimeOut":0
    },{
      "@odata.type":"#Model.DataSet","Id":"dataset ID","Name":"forGinieDataset1","Description":null,"Path":"/forGinie/forGinieDataset1","Type":"DataSet","Hidden":false,"Size":973,"ModifiedBy":"D2N3KZL2\\GainAdmin","ModifiedDate":"2019-12-02T13:42:07.707+05:30","CreatedBy":"D2N3KZL2\\GainAdmin","CreatedDate":"2019-12-02T12:35:43.227+05:30","ParentFolderId":"217f25cd-4770-4e4f-a870-64e514d44d7f","IsFavorite":false,"Roles":[
        
      ],"ContentType":null,"Content":"","HasParameters":false,"QueryExecutionTimeOut":0
    },{
      "@odata.type":"#Model.Report","Id":"dataset ID","Name":"Report1","Description":null,"Path":"/forGinie/Report1","Type":"Report","Hidden":false,"Size":14792,"ModifiedBy":"D2N3KZL2\\GainAdmin","ModifiedDate":"2019-12-02T12:35:43.583+05:30","CreatedBy":"D2N3KZL2\\GainAdmin","CreatedDate":"2019-12-02T12:30:15.663+05:30","ParentFolderId":"217f25cd-4770-4e4f-a870-64e514d44d7f","IsFavorite":false,"Roles":[
        
      ],"ContentType":null,"Content":"","HasDataSources":true,"HasSharedDataSets":true,"HasParameters":false
    }
  ]
}

When I'm trying to get the data sets inside the folder with the following URL

http://d2n3kzl2//reports/api/v2.0/folders(folder ID)/catalogitems/Model.DataSet

I'm getting the available datasets in side the folder

 

How can I get the data from the data set inside the folder?

No RepliesBe the first to reply