Aggregation feature in power bi report server

Question

Can we apply aggregation feature in power bi report server ?(I'm using SQL server direct query )

v-qiuyu-msft · Answer

Hi&nbsp;wesen,&nbsp;
&nbsp;
In Power BI desktop optimized for report server version, get data from SQL database in DirectQuery mode, you can create a measure use aggregation&nbsp;functions, eg: SUM, Count, then publish the report to Power&nbsp;BI report server.&nbsp;
&nbsp;

&nbsp;
Best Regards,Qiuyun Yu&nbsp;

wesen · Answer

Hi&nbsp;v-qiuyu-msft&nbsp;&nbsp;Sorry for my explanation, I mean it like the below link.https://docs.microsoft.com/en-us/power-bi/desktop-aggregations&nbsp;Thank you!

v-qiuyu-msft · Answer

Hi&nbsp;wesen,&nbsp;
&nbsp;
Based on my research, manage aggregation&nbsp;feature isn't supported in Power&nbsp;BI report server yet. Please post a idea here:&nbsp;https://ideas.powerbi.com/forums/265200-power-bi-ideas
&nbsp;
Best Regards,Qiuyun Yu

anonymous · Answer

Hi,&nbsp;I might as well ask in this thread: Any news on this. I read that aggregations now are "generally available" from&nbsp;https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-2019-feature-summary/.&nbsp;I cannot find any clear answer or any Power BI Ideas asking for this either so I just wanted to see if you have any more info.

d_gosbell · Answer

Unfortunately there has been no change in this area. The Aggregation feature is still only supported in the cloud service and is not available in Report Server.

Forum Discussion

Aggregation feature in power bi report server

5 Replies

Related content

Power BI July 2026 Feature Summary

Data Aggregation issue

Hidden Features

Feature Usage and Adoption symantic model report

Feature Usages and adption report custom date changes