Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

measure missing upon reopening

so i set up the measures, fitted them into the graphs and closed the file.

 

after about 1 month, i reopend the file to find that all my graphs are replaced with an error message and all my measures are gone. my file is essentially useless now. do you know how i can find my measures back again? 

 

thanksss!

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    did you publish from your Power BI Desktop to a workspace or even an app? In that case you can connect a client like DAX Studio or SSMS and run an MDX query against the Measures table.

     

    Select * from $SYSTEM.TMSCHEMA_MEASURES

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Anonymous 

    Which data source do you connect to?

    Which version of Power BI do you use?

    Is it a pbix file or a pbit file?

     

    Best Regards

    Maggie

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi, my file is pbix and i connect it to an excel file. i didnt publish it before since its halfway done.

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      6 years ago

      Hi Anonymous 

      Could you share the error message?

       

      Best Regards

      Maggie