Forum Discussion

hildebolt's avatar
hildebolt
Icon for Advocate I rankAdvocate 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.

hildebolt's avatar
hildebolt
Icon for Advocate I rankAdvocate I
2 years ago

Thanks a lot for the response!

Yep, thats a good point. Do you know how I can exclude them? For some reason I can't just remove the columns, as it still returns the same error. 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

You probably didn't catch them all.  Use Value.Is to validate across columns.