Forum Discussion
"Invalid AS model object name" for every create table statement
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 TeamIf 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
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
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?
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 TeamIf 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
I did this of course. I am still unable to create any new table, following this error.
Even with:
CREATE TABLE schema._FantasticTable123 ( [id] INT NOT NULL ) GOI get: Invalid AS model object name: Measures of type Table. Error: The name of the object 'Table' cannot be the reserved string 'Measures'..
Also when I try to create a new schema.
Hi K_Schmidt ,
Could you double check if there is a Measures table under Warehousse?
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE';As previously described, they are invisible, so they are easy to ignore.
You can delete the Measures table once under the default schema and once under the custom schema:
DROP TABLE YourWarehouseName.YourSchemaName.Measures;Best Regards,
Gao
Community Support Team