Forum Discussion
saranrajk
6 years agoHelper II
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