Forum Discussion

K_Schmidt's avatar
K_Schmidt
Frequent Visitor
1 year ago
Solved

"Invalid AS model object name" for every create table statement

Hey all!

 

I got the error "Invalid AS model object name: Measures of type Table. Error: The name of the object 'Table' cannot be the reserved string 'Measures'..", when I tried to create a table called "Measures". Okay, got it, changed the name to "_Measures" and "_MeasuresTable" with the same error.

 

In fact, now I get this error message for every table I try to create via SQL query, also with completely random naming. Fabric seems to create the tables anyway, as I can select or drop them via query - but I cannot see them in the explorer or add them to a semantic model, so they are somewhat useless or at least not manageable.

 

I am using a Warehouse with an own schema where I want to create tables. I have created other tables there before, that are visible in explorer and work fine.

 

Seems like a bug to me, any idea how to fix it?

 

Edit: I also get this error when refreshing with the top left "refresh" button under the "home" tab.

 

Edit 2: Info: I did not accept this as the solution, as it is certainly not one (its part of the problem descriptione even). I still cannot create any new table! Only solution so far has been deleting and recreating the whole workspace.

 

 

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi K_Schmidt ,

     

    After some research, I think this is an error triggered by the word reserved. 'Measures' has been used in the semantic model, which is designed to avoid ambiguity.

    You can use other names, like:

    Note that you are deleting the Measures table that you created earlier.

     

    Best Regards,
    Gao

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi K_Schmidt ,

     

    I reproduced the behavior above. This should be an issue, I will contact the Product team and I will update below with any response.

    Best Regards,
    Gao

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

    • K_Schmidt's avatar
      K_Schmidt
      Frequent Visitor

      Thank you,

       

      did you by chance reveive any feedback?

       

      BR

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi K_Schmidt ,

     

    After some research, I think this is an error triggered by the word reserved. 'Measures' has been used in the semantic model, which is designed to avoid ambiguity.

    You can use other names, like:

    Note that you are deleting the Measures table that you created earlier.

     

    Best Regards,
    Gao

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

    • K_Schmidt's avatar
      K_Schmidt
      Frequent Visitor

      Yes, this is the reason why I cannot create the Measure table, which is understood and fine. But it does not explain the follow-up errors?

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi K_Schmidt ,

         

        -- Please try deleting the Measures table that you created earlier. After deleting this hidden “Measures” table, creating a new table works fine.

         

        I'm guessing that it can't ignore the error of the first creation of the table named Measures when creating subsequent tables, and that's why it's reporting the error over and over again. In any case, please consider avoiding the use of these keywords when creating tables. (It would actually be better to have a document listing these keywords, but I was not able to retrieve it.)

         

        Similar problems:

        Solved: I cannot name a table "Measures", throws error, is... - Microsoft Fabric Community

         

        Best Regards,
        Gao

        Community Support Team

         

        If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
        If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

        How to get your questions answered quickly --  How to provide sample data in the Power BI Forum