Group by columns are not saving when I'm trying to configure my Aggregations table

[mammenga]

Hello Community! 

I'm trying to create an aggregations tables to agg average hours in multiple columns.  To do this, I have used Group By to create new sum and count columns.  I get it to work and save the file but when I reopen the file, I'm receiving errors in the Group By sum columns and have to go into power query and reselect the column I want to sum for each sum.  I don't think this is a modeling issue as I have my agg table set as import, my dim tables set as Dual, and my fact table set as direct query.  I guess I can always create a view table and pull it into power BI but I was hoping I could figure out how to do this in power query. Any ideas?

Thanks

[Anonymous]

@mammenga 
Try change the tables into import storage mode.  And what is the error message? Select the error cells to check.

Paul Zheng _ Community Support Team