I'm losing all my measures and calculated columns

[KH11NDR]

Hi GUYS,

Something critical has happened to me three times now, when I make changes in query editor and then press close and apply, If there's an error I can see the table, but i've lost all my measures and calculated columns .  I'm pretty sure that hasn't happend before and I don't think it s]hould if oit does.

Any help on why and is this a bug?

[v-shex-msft]

Hi @KH11NDR,

Calculate fields are based on data model who generated from query tables.

If there are any issues appear on your query tables so power bi can't apply changes and regenerated these data model tables.

For this scenario, these calculate formulas will also break due to dependency fields/table broken.

I'd like to suggest you double check on your query table steps to fix if any issues appears on query editor side.

Regards,

Xiaoxin Sheng

[KH11NDR]

Is there not a place where you can save them or automatically save them for you?.  Lucky I keep saved versions.

[v-shex-msft · Accepted solution]

Hi @KH11NDR,

>>Is there not a place where you can save them or automatically save them for you?.  Lucky I keep saved versions.

Yes, power bi has its recovered folder, you can find it in option -> auto recovery.

Regards,

Xiaoxin Sheng