Forum Discussion

saranrajk's avatar
saranrajk
Helper II
6 years ago

How to get aggregated values using Power BI report server rest API?

Hi, 

I'm trying to get aggredated value from the shared data using using the following API url.

http://localhost/reports/api/v2.0/DataSets(dataset_id)/Model.GetAggregatedValue?ColumnName=ingredient_price&Aggregation=sum

Nothing is working for me regarding Model.

for example model.getdata is also not working

http://localhost/reports/api/v2.0/DataSets(dataset id)/Model.GetData

and I'm getting the error in attached image.

what is Model?

and for /dependentitems 

http://d2n3kzl2//reports/api/v2.0/DataSets(dataset id)/DependentItems

I am getting the following error

{
  "error":{
    "code":"","message":"No HTTP resource was found that matches the request URI 'http://d2n3kzl2/reports/api/v2.0/DataSets(7af2bc9a-738d-47f9-a1da-2a182d0b8509)/DependentItems'."
  }
}

How to resolve this too?

 

Thanks in Advance

No RepliesBe the first to reply