cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
po Member
Member

Advanced editor - error and error on summarized table

Hi,

 

We have a report with imported view and one of columns on view has chnaged name - it imports o.k but notice that one of the tables we have created with summarize now has an error and due to this table - column concerned not changed which used in this but when look in advanced editor.  How can we correctly resolve when column on imopretd table has chnaged its name - afecting other visuals as well and didn;t want to have to remove table altogether and redod joins etc.

 

Even when go to navigation and look at tables/views available it looks lkike it is seeing cached version and not realising name has changed - how can we force clear cache or something similar?

 

It looks like explcitly gpoing to refresh preview then applying changes will clear the error but not sure if other/better ways tahn havcing to go into advanced editor to do this?

 

col_name_change.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Advanced editor - error and error on summarized table

Hi @po ,

Normally, we will fix this kind of error with the method you mentioned above.

In addition, we also could modify the M query in Advanced Editor directly but I think the easiest way is clicking refresh preview then applying changes if you're not familiar with M query.

If you want to modify the M query in Advanced Editor, please check if the column name is changed in the step of "Changed type".

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Advanced editor - error and error on summarized table

Hi @po ,

Normally, we will fix this kind of error with the method you mentioned above.

In addition, we also could modify the M query in Advanced Editor directly but I think the easiest way is clicking refresh preview then applying changes if you're not familiar with M query.

If you want to modify the M query in Advanced Editor, please check if the column name is changed in the step of "Changed type".

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
po Member
Member

Re: Advanced editor - error and error on summarized table

Hi,

 

Thanks for reply.