Forum Discussion

hildebolt's avatar
hildebolt
Advocate I
2 years ago
Solved

Nested tables causing refresh issues in PowerBI Service

I have recently started having issues with automatic refresh in PBI Service, all with the same approximate error message:   Expression.Error: The column 'xxxx' of the table wasn't found.. xxxx. . T...
Need Help
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    2 years ago

    When your group by includes "all rows" that will carry these columns around. Instead of group by consider using Table.SelectColumns to only pick the columns you need.

lbendlin's avatar
lbendlin
Super User
2 years ago

When your group by includes "all rows" that will carry these columns around. Instead of group by consider using Table.SelectColumns to only pick the columns you need.

hildebolt's avatar
hildebolt
Advocate I
2 years ago

Ah that could well be the main issue.. Thanks a lot.