Forum Discussion

esjetmore's avatar
esjetmore
Frequent Visitor
1 year ago
Solved

New Column Not Showing Up In Semantic Model

Hello all! I have a SQL database in Fabric and a table called "tick". I have used the following to add a column to that table. When I run this code in the SQL endpoint it fails, but if I run it in th...
Need Help
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    1 year ago

    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

     

NimaiAhluwalia's avatar
NimaiAhluwalia
Continued Contributor
1 year ago

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.