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
Hello esjetmore
if the below columns are in the table tick than isnstead of adding it separetlty by using an endpoint or even it does not appear in the model after your refresh the model you can create a calculated column in power bi as a workaround, as many people are facing this issue this might be a glitch from fabric's end.
(order_date, order_code, tkt_code
My data is in Direct Lake mode, so that is not possible. Calculated columns are not available for that connection type. https://learn.microsoft.com/en-us/fabric/fundamentals/direct-lake-overview
Hello esjetmore
Thanks for mentioning that, you can try using the direct query mode, obviously you wont be able to create a column in this mode as well but worth trying if the data is getting pulled properly, but if your data size is not to large you can use the import mode as well which gives you more flexibility to model and transform the data in the power bi, than you can try concatinate the columns as a calculated column.
Our data size is large and updates every 20 minutes. We can't use import mode, and direct query does not solve our problem either. Is there really no way to do this? Adding a column to an existing table seems like basic functionality.
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 LearnIf you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards