topic Re: "Invalid AS model object name" for every create table statement in Data Warehouse

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

K_Schmidt — Mon, 04 Nov 2024 08:37:42 GMT

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.

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

Anonymous — Wed, 02 Oct 2024 03:04:06 GMT

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

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

Anonymous — Tue, 08 Oct 2024 02:23:38 GMT

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

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

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

K_Schmidt — Mon, 21 Oct 2024 06:01:32 GMT

Thank you,

did you by chance reveive any feedback?

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

K_Schmidt — Mon, 21 Oct 2024 06:04:04 GMT

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?

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

Anonymous — Wed, 30 Oct 2024 07:46:02 GMT

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

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

K_Schmidt — Mon, 04 Nov 2024 08:33:38 GMT

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.

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

Anonymous — Tue, 05 Nov 2024 03:10:12 GMT

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

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

K_Schmidt — Tue, 05 Nov 2024 06:30:35 GMT

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