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