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

I'm losing all my measures and calculated columns

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: I'm losing all my measures and calculated columns

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.

17.PNG

 

Regards,

Xiaoxin Sheng

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



For learning resources/Release notes, please visit: | |
3 REPLIES 3
Community Support Team
Community Support Team

Re: I'm losing all my measures and calculated columns

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

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



For learning resources/Release notes, please visit: | |
KH11NDR Member
Member

Re: I'm losing all my measures and calculated columns

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

Community Support Team
Community Support Team

Re: I'm losing all my measures and calculated columns

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.

17.PNG

 

Regards,

Xiaoxin Sheng

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



For learning resources/Release notes, please visit: | |