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

[K_Schmidt]

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 · Accepted solution]

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]

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]

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

[K_Schmidt]

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
)
GO

I 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.

[Anonymous]

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

[K_Schmidt]

 Yes, I deleted those as well, it did not help. I have dropped the whole workspace now.

[Anonymous]

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]

Thank you,

did you by chance reveive any feedback?

BR