topic Re: Aggregation feature in power bi report server in Report Server

Aggregation feature in power bi report server

wesen — Sun, 22 Dec 2019 11:19:57 GMT

Can we apply aggregation feature in power bi report server ?

(I'm using SQL server direct query )

Re: Aggregation feature in power bi report server

v-qiuyu-msft — Wed, 25 Dec 2019 03:17:41 GMT

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

Best Regards,
Qiuyun Yu

Re: Aggregation feature in power bi report server

wesen — Mon, 30 Dec 2019 05:20:37 GMT

Hi v-qiuyu-msft

Sorry for my explanation, I mean it like the below link.

https://docs.microsoft.com/en-us/power-bi/desktop-aggregations

Thank you!

Re: Aggregation feature in power bi report server

v-qiuyu-msft — Tue, 31 Dec 2019 07:34:57 GMT

Hi wesen,

Based on my research, manage aggregation feature isn't supported in Power BI report server yet. Please post a idea here: https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best Regards,
Qiuyun Yu

Re: Aggregation feature in power bi report server

Anonymous — Mon, 31 Aug 2020 11:59:18 GMT

Hi,

I might as well ask in this thread: Any news on this. I read that aggregations now are "generally available" from https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-2019-feature-summary/.

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.

Re: Aggregation feature in power bi report server

d_gosbell — Mon, 31 Aug 2020 22:53:04 GMT

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.