Forum Discussion

joakimfenno's avatar
joakimfenno
Helper V
1 year 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 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi joakimfenno ,

 

Thanks for the reply from AndyDDC .

 

You can refresh individual tables using the Enhanced Refresh API. This method allows you to specify which tables to refresh.

 

This is a simple example code:

import sempy.fabric as fabric

# Define the dataset and workspace
dataset = "YourDatasetName"
workspace = "YourWorkspaceName"

# Objects to refresh
objects_to_refresh = [
    {"table": "YourTableName"}
]

# Refresh the dataset
fabric.refresh_dataset(workspace=workspace, dataset=dataset, objects=objects_to_refresh)

# List the refresh requests
fabric.list_refresh_requests(dataset=dataset, workspace=workspace)

 

For more information please see:

Refreshing Individual Tables and Partitions With Semantic Link (fabric.guru)

 

If you have any other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

  • joakimfenno's avatar
    joakimfenno
    Helper V
    1 year ago

    Hi

    can this be used to add new columns (i.e update the model)?

     

    what is dataset? is that the name of the semantic model?

     

    do you run this within fabric (notebook) or outside?

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi joakimfenno ,

       

      Thanks to all for their interest in this case.

       

      1. Can this be used to add new columns (i.e. update the model)?

      It can be used to refresh a single table, not to update.

       

      2. What is Dataset and is this the name of the semantic model?

      Yes.

       

      3. Are you running it inside the fabric (Notebook) or outside?

      Run it in a Fabric notebook, like the one shown below.

       

      If you have any other questions please feel free to contact me.

       

      Best Regards,
      Yang
      Community Support Team

       

      If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
      If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!