Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
saranrajk
Helper II
Helper II

how to get aggregated data from Power BI report server using Rest API?

Hi,

I'm trying to get the aggregated result from POWER BI report server rest API by using the following url

http://{server}//reports/api/v2.0/Datasets(23617073-a6d9-45e8-8f2c-abc78bdfb267)/Model.GetAggregatedValue?ColumnName=ingredient_name&Aggregation=6

 

I can able to retrieve data from the datasets

 

The following are the parameters

ColumnNameThe name of the DataSet column to aggregate the value for.(I give dimension name here)

Aggregation The type of aggregation to use on the specified column. Values come from the KpiSharedDataItemAggregation enum.(for Aggregation they mentioned to use KpiSharedDataItemAggregation and I'm using 6 as value as per the documentation https://docs.microsoft.com/en-us/openspecs/sql_server_protocols/ms-rsrest/a7f68efc-4622-47be-949c-ed...  if this is right? where can I mention measure)

 

Parameters An array of DataSet parameters to use when executing the query.

Format for parameters 

{
   "Parameters": [
    {
       "Name": "string",
        "Value": "string"
    }
    ]
}(Hope this is used for filter if so, how can I give values)

 

 

1 REPLY 1
saranrajk
Helper II
Helper II

Hi, Can anyone resolve this issue for me?

 

Thanks in advance

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.