Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Dax code not available after reboot PBI

Hi,

I created some columns using DAX and I reboosted my laptop due to PBI errors. 

After reopen PBI desktop, I cannot suddenly edit DAX code which is not activated. 

there used to be code I wrote..

 

 

 

 

General Comment
Need Help
Show and Tell
Tips and Tricks
  • Cookistador's avatar
    Cookistador
    1 year ago

    Can you try to open the semantic model with Tabular Editor V2?

    I met a similar issue a few months ago, I opened it with tabular editor made a small change (like replace the name of a measure), save it and then in Power BI, I was able to see my dax measure

     

    If it is not working, can you see your code in tabular editor ?

  • Ritaf1983's avatar
    Ritaf1983
    1 year ago

    Hi Anonymous 

    Possible reasons for being unable to edit calculated columns in DAX:

    • The PBIX file was not saved before the reboot, causing the loss of recent changes.
    • The data model is corrupted, preventing Power BI from recognizing the calculated columns.
    • A permissions issue or an unexpected bug is preventing edits.

    Suggested checks:

    • Verify if the calculated columns still appear in the Fields pane.
    • Look for a backup of your PBIX file. Power BI sometimes creates auto-recovery files in:
      C:\Users\YourUserName\AppData\Local\Microsoft\Power BI Desktop\Temp Saves

    You can also try to get to recovery folder from options:

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

3 Replies

  • Cookistador's avatar
    Cookistador
    Icon for Super User rankSuper User
    1 year ago

    Can you try to open the semantic model with Tabular Editor V2?

    I met a similar issue a few months ago, I opened it with tabular editor made a small change (like replace the name of a measure), save it and then in Power BI, I was able to see my dax measure

     

    If it is not working, can you see your code in tabular editor ?

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    1 year ago

    Hi Anonymous 

    Possible reasons for being unable to edit calculated columns in DAX:

    • The PBIX file was not saved before the reboot, causing the loss of recent changes.
    • The data model is corrupted, preventing Power BI from recognizing the calculated columns.
    • A permissions issue or an unexpected bug is preventing edits.

    Suggested checks:

    • Verify if the calculated columns still appear in the Fields pane.
    • Look for a backup of your PBIX file. Power BI sometimes creates auto-recovery files in:
      C:\Users\YourUserName\AppData\Local\Microsoft\Power BI Desktop\Temp Saves

    You can also try to get to recovery folder from options:

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous,

     

    We would like to follow up to see if the solution provided by the super users Ritaf1983 / Cookistador  resolved your issue. Please let us know if you need any further assistance.


    If our super users response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

    Regards,
    B Manikanteswara Reddy