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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Pat_PBI
Regular Visitor

Aggregation (new feature)

Hello,

I have two SAP HANA sources, both are import. The preview feature of Manage Aggregation is activated.

 

Main

YEAR / MONTH / Sales

 

Aggregation

YEAR / Sales

 

I followed the instruction: Right click on the "Aggregation" table, choose Manage Aggregation. In the popup I choose Group by for YEAR and Sum for Sales. Then try selecting a detail table and my main table is greyed out (not selectable). I created other table (all from HANA source) and everything in detail table is always greyed out.

 

Are SAP HANA sourced table are supported by this new feature ?

Thanks, Pat

1 ACCEPTED SOLUTION
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi Pat, 

 

Almost all the data sources are supported. Please refer to power-bi/desktop-aggregations#data-source-types.

But as a preview feature, there are some limitations. The Detail table should be in Direct Query mode. Please refer to power-bi/desktop-aggregations#validations.

>>>Detail table must be DirectQuery, not Import. Public preview limitation.

Considering these limitations, you can try it again.

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi Pat, 

 

Almost all the data sources are supported. Please refer to power-bi/desktop-aggregations#data-source-types.

But as a preview feature, there are some limitations. The Detail table should be in Direct Query mode. Please refer to power-bi/desktop-aggregations#validations.

>>>Detail table must be DirectQuery, not Import. Public preview limitation.

Considering these limitations, you can try it again.

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for the reply, is it planned for the product to be able to have an imported Detail Table 

Hi @Pat_PBI,

 

Yes, these limitations will be removed in the GA release. 

>>>During this public preview for aggregations, the following validations are also enforced. We intend to remove these validations upon releasing for general availability.

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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