Column not found error

[Anonymous]

Hi Team,

I went through many of the solutions provided to takle this issue.  however, in my scenario the situation is different.

I'm quering data from Teradata view and I changed a column name recently for one of the columns in my Teradata view.

In Powerquery editor, i have only two steps "Source" and "Navigation" and no where I have used this column for any sort of transformation.

So, now  how to do resolve this "Column not found" error, when I'm not referencing to this column at all? 

[Syndicate_Admin]

I have a problem may

I have a data base that provides me with more than 1000 columns with product characteristics to combine with my price lists.

The problem is that for example when you are going to put new products a month you have changed 30 or 40 columns of name

and for example if you had a command to convert the fields to text and another order to delete the null fields

You have 80 errors of more than a minute each error.
Is there a way to disable the errors and for example make the 960 that are fine and then make you the ones that are manually or ignore them?

Because many times when there are no columans you do not have to do anything pq do not exist and it does not matter that you do not convert to text a column that no longer exists

Thanks in advance

[Fowmy]

@Anonymous 

Could you share the M code from the advanced editor ?
 

[Anonymous]

@Fowmy ,

Below is the m query

let
Source = Teradata.Database("ttttttt", [HierarchicalNavigation=true]),
D1 = Source{[Schema="xxx"]}[Data],
ITOp= D1{[Name="zzz"]}[Data]
in
ITOp

[Anonymous]

@Fowmy Hi Fowmy,

Any idea why i get the error. 

[Fowmy]

@Anonymous 

can you do a fresh connection two terror data again?

[Anonymous]

@Fowmy  I did that and I get the same message in new query as well

[v-easonf-msft]

Hi,  @Anonymous 

It is recommended to reconnect to the data source after clearing the data source credentials.

Best Regards,
Community Support Team _ Eason

[Anonymous]

Ok I will try that and confirm 

[v-easonf-msft]

Hi,  @Anonymous 

Could you please tell me whether your problem has been solved?

If yes, you could accept the helpful answer as solution. You could also share your own solution here to close this thread.

If you still have no idea about your problem, you can open a support ticket with MSFT to seek technical support , usually they will have better suggestions.

Best Regards,
Community Support Team _ Eason