Forum Discussion
Solved
Composite model Direct query columns cannot be summarized
Hi! We have a composite Power BI model which is mainly built by direct query Microsoft SQL data tables. Previously everything has worked fine, but suddenly now aggregating columns is not workin...
Thanks! I didn't actually need Tabular Editor and was able to make the change in Power BI desktop after I deleted the calculation group.
Thanks for the quick response danextian ! We have a couple of users modifing this report. It does look like my colleague has created a calculation group by mistake. I'm not that familiar with calculation groups, is there a way to turn delete these and turn on implicit measures?