Forum Discussion
New Column Not Showing Up In Semantic Model
Hi esjetmore ,
Sorry to know it didn’t help. Its most likely an unintended bug. Please consider reaching out to Microsoft Support. You can provide them with all the troubleshooting steps you've already taken, which will help them understand the issue better and provide a resolution. They might be able to identify something specific about your admin account setup or provide a solution that isn't immediately obvious.
Below is the link to create Microsoft Support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thanks and Regards
Hi esjetmore ,
Thanks for reaching out to the Microsoft fabric community forum.
It is not executing in SQL analytics endpoint because it functions as read only mode that means that Data Definition Language (DDL) statements such as create table, alter table and drop table are not supported. This endpoint is designed primarily for querying and analysing data, rather than modifying its structure.
What is the SQL analytics endpoint for a lakehouse? - Microsoft Fabric | Microsoft Learn
For the Semantic model part, try to create a new semantic model to check if the new column gets included
Please review the limitations document to identify any potential conflicts affecting the semantic model update:
Limitations for SQL database (preview) - Microsoft Fabric | Microsoft Learn
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards
Thank you for the response! I don't need the ALTER TABLE to run in the SQL endpoint because I was already able to get it to run in the SQL database. In the SQL database the new column "k_times" is visible:
But in the SQL Analytics Endpoint, it still does not appear:
In the new semantic model I created, the new column is also missing. I reviewed the documentation you shared and there is no information regarding semantic model shifts or the creation of new columns that would effect this.
Can you recommend an alternative way of creating a new column in an existing delta table without dropping the table?
Hi esjetmore ,
Sorry to know it didn’t help. Its most likely an unintended bug. Please consider reaching out to Microsoft Support. You can provide them with all the troubleshooting steps you've already taken, which will help them understand the issue better and provide a resolution. They might be able to identify something specific about your admin account setup or provide a solution that isn't immediately obvious.
Below is the link to create Microsoft Support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thanks and Regards