cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
saranrajk Regular Visitor
Regular Visitor

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?

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)