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.
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
ColumnName - The 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)
Hi, Can anyone resolve this issue for me?
Thanks in advance
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
13 | |
10 | |
5 | |
4 | |
3 |