Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |