Forum Discussion

joakimfenno's avatar
joakimfenno
Helper V
2 years ago
Solved

Fabric - semantic model - refresh

I just started with semantic models in fabric What is the best way to resync a table a table from the source (i.e add a new column to a table in the model that has been added to the source table). ...
Warehouse
  • joakimfenno's avatar
    joakimfenno
    1 year ago

    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 

frithjof_v's avatar
frithjof_v
Community Champion
1 year ago

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.

joakimfenno's avatar
joakimfenno
Helper V
1 year ago

thanks the plan is to do it in the next phase