Forum Discussion
Fabric - semantic model - refresh
I found the issue
I had one view in the warehouse with two columns having identical names where one of them had a capital letter
I tried to refresh the warehouse from fabric gui and received the duplicate column name error message
It is fully possible (at least from sql endpoint) to create a view with two columns names aa and Aa for example. However its not supported in semantic models and semabtic model will not give you an indication of this issue
Hi joakimfenno for adding new columns to a semantic model, in the Fabric UI you'll need to use the Edit Tables button, but you can filter what tables will be included in the refresh. E.G in the image below I have added a new column to my Warehouse employees tables, but to get that column to appear in a custom semantic model, I need to open the model and click Edit Tables. I can then enable/disable which tables I want the metadata to be refreshed for.
I tried that and selected the table with thenew column only but that made all other tables dissapeared
and not only that, it seems like there is no optioon to reverse the change?
In this case my model (datatypes, relations, measures etc.) was huge
Can I reverse the change somehow?
Also, if I have two new columns in a table, how do I add one of them to the model?
and actually, I tried with another model now, edit table did not pick up the new columns (source is a view in warehouse sourced from lakehouse)
I should have also stated that you're existing tables will need to be selected, my apologies for not being more clear on that.
As for column-by-column I don't believe you can do that.
unfortunatley I had ro recreate the whole model
seems like there is no way to version control semantic models yet?
You can link the Workspace to Azure DevOps or GitHub and source control the Semantic Models there:
If you are using a view as data source, the queries will not run as Direct Lake instead they will run as DirectQuery.
Have you considered instead to use an Import mode model, created in Power BI desktop, to connect to your Fabric Warehouse?
Then you get more customization options, e.g. option to select specific columns.
thanks the plan is to do it in the next phase
