Aggregations doesn't appear to work for detail table which is import mode

[po]

Hi,

Looking at the aggreagations feature in power bi desktop as per below and had interpreted documentation as suggesting could base aggregation on table which ahd been imported but when try this get message must be a directquery table to be used as detail table.

Is this a bug and is there a plan to allow aggregations on import tables in future?

Also is it the case that if use aggregatiosn and have the raw detail table visible (i.e. sales) but sales_agg hidden that power bi will automtically determine the table it needs to get data from based upon whwat useer has selected - similar to aggregate_awareness in business objects?

 

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

All Power BI Import and (non-multidimensional) DirectQuery sources work with aggregations.

[Anonymous]

"Detail table must be DirectQuery, not Import. "

hello everybody.

was this fixed in the release?

thanks in advance

[v-lili6-msft]

hi, @po 

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.

And refer to blog post says:

If you are querying even a DirectQuery table with 250 millions of rows, but you are only querying it by Date, then Power BI act differently. Power BI will not send a query to the data source of the fact table. It will query the aggregated table in the memory instead, and you get a fast response. Power BI only will switch to the table underneath, if aggregated tables cannot answer the question.

http://radacad.com/power-bi-fast-and-furious-with-aggregations

Best Regards,

Lin

[po]

Hi,

Thanks for reply.

Notice mentions We intend to remove these validations upon releasing for general availability.

Do you know when aggregations expected to be generally available?

Also if have sales table with sales_qty is it the case that only need to have this visible on the detail table as part of dataset

i.e. no need to define multiple sales measures at each level - just define aggregate tables?

Thanks

[v-lili6-msft · Accepted solution]

hi, @po 

1. Power bi product team is improving this preview feature, I can't give you the exact time, you could post subscribe the power bi blog to get the latest updates.

2. As the blog said, when the query could be get in aggregate tables, it will not send the query to datasource.

Best Regards,
Lin

[po]

Hi,

Thanks for update