Issue deleting a table - it's affecting formatting of another unconnected table

[Anonymous]

I delete a field (Table3) from my Query or from the Report view - and as soon as I do that, the format of data in another unconnected table (Table1) is affected. The data in Table1 changes from Number to text, and visuals that use the data change titles from "title" to "sum of title". 

[v-shex-msft]

Hi @Anonymous,

When you delete table from report view, it will also remove query in query edit, then it will re-generate data model and load data.

I think your issue is caused with re-generate data model, it seems like power bi recognize your data column as wrong type and do summarize on it.

For your scenario, you can manually modify column type and remove wrong one from visual, then use correct one to replace.

Regards,

Xiaoxin Sheng

[Anonymous]

Thanks for your reply! This happens both when I delete the unrelated table from Report view, and when I delete the unrelated query from the Power Query Editor.

I am also not sure why the type is changing at all -- in my Query Settings, one of the applied steps it to change the type of all the columns to Decimal Number.

I'd really like to not have to fix all the columns... there are over 60 of them to re-add to the table.

[Anonymous]

I also just tried to manually change the type and I am unable to. The Formatting option in the Modelling tab is now grayed-out and I am unable to select anything.

[v-shex-msft]

HI @Anonymous,

I can't reproduce this issue on my side.

Did you have a copy of original file? You can try to enter to 'query edit' to delete tables and confirm if your columns type changed.

>>The Formatting option in the Modelling tab is now grayed-out and I am unable to select anything.

Can you please provide some detail information about this ?

Regards,

Xiaoxin Sheng