Delete collumn from table and refresh

[brunoRF]

Hi all,

Do you know how to permanantly delete collumn from a table and refresh with a new table without the collumns?

When I do it I get an error saying it could not not finde the deleted collumns.

Thanks in advance

[Anonymous]

@brunoRF  For visual tables you should be able to remove the information from the "Values" section in visualizations. If it is a column in your data you can also delete this in the query editor. 

If this doesn't address your issue can you post a picture of what you want to delete for more context? 

[brunoRF]

yes but when i delete them in the query and i delete them in sql...when i refresh the table power bi still asks for the deleted collums

[v-lili6-msft]

hi, @brunoRF 

You should have some steps in your query that explicitly reference the deleted column. You can open advanced editor on  your query, then find the deleted column in it, and correct the codes in advanced editor. This way, you will be able to refresh data in Power BI Desktop.

Best Regards,

Lin