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 again
I still have issues with the GUI refresh
when trying Edit tables - refresh I receive this (screenshot below)
Are you using default or custom semantic model?
Did you delete a table column?
You could try to deselect a table from the semantic model, apply, and then reselect it again. If you do this, you could perhaps lose any measures which belongs to that table (I'm not sure) and relationships. But perhaps deselecting a table, apply, and then reselect the table will work.
I believe alternatives to the web GUI is Tabular Editor or Power BI Desktop (Power BI Desktop can't edit direct lake models yet, but it can create and edit Import mode models which offer more customization options).
custom model
I changed a source object from view to tabel (same name)
I tried deslect - select but that did not work
I will try the API for refreshing ythe model but this is frsutrating since some of our users will use the GUIHi
this is urgent and frustrating
shall I create a new forum topic for this issue specifically?
I think I will recommend to create a support ticket https://support.fabric.microsoft.com
Also, I think there are two separate concepts here:
- Edit the schema of the model ("Edit Tables"). https://learn.microsoft.com/en-us/fabric/get-started/direct-lake-edit-tables
- Refresh the data content. https://learn.microsoft.com/en-us/fabric/get-started/direct-lake-overview#refresh
I believe the first one is the cause of your issues?
The latter can be done automatically, in that case there would be no need for your users to refresh.
Perhaps you will find your issue listed as a Known issue here: https://learn.microsoft.com/en-us/fabric/get-started/fabric-known-issues#currently-active-known-issues
Similar topics:
Using Tabular Editor to edit semantic models may be an alternative.
Or using Power BI desktop (import mode).
Are you using Lakehouse or Warehouse?
Anyway, using views is bad for performance in direct lake semantic models. Views make the report queries fall back to DirectQuery (which has lower performance than Direct Lake). So the recommendation is to use tables, not views, if you wish to use Direct Lake mode.
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