Forum Discussion
Solved
Missing Column that Doesn't Exist
Hello - I have a query that we've been actively using for a few years now. Recently, a report from our data mart was updated and removed a few columns. I went in and updated all queries associated wi...
Things finally refreshed correctly! I don't know what piece did it, but I once again went through every query step by step and refreshed the caches. Something finally clicked on the back end to make it stop asking for the nonexistent column.
That's one of the reasons why Table.SelectColumns is often better/more robust than Table.RemoveColumns .
Somewhere in your dataflow/datamart there's still a cache hanging around. Can you afford to delete the query/table, update the dataflow/datamart, and then recreate it?
I've already deleted and rebuilt the queries that were associated with the source data and rebuilt the relationships...Are you referencing a different method than those?