Forum Discussion

wesen's avatar
wesen
Icon for Helper I rankHelper I
6 years ago

Aggregation feature in power bi report server

Can we apply aggregation feature in power bi report server ? (I'm using SQL server direct query )
Aggregation feature
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi wesen, 

 

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