Forum Discussion

ToddChitt's avatar
ToddChitt
Super User
1 year ago
Solved

Semantic Model Refresh pipeline task shows no tables

I have a simple Fabric Pipeline task that loads data into warehouse tables. The last step is a Semantic Model Refresh task. I have had this Semantic Model for months now and have refreshed it numerou...
data pipeline
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi ToddChitt,

    Thanks for reaching out to the Microsoft fabric community forum.

    This does sound like a regression in how the task fetches table metadata from the semantic model. We've seen a few similar reports come in, and it's currently under internal review. As you have already raised the issue in the Idea Forums, in the meantime, here are a few steps that have helped others work around it:

    * Try disconnecting and reconnecting the semantic model in the task click the pencil icon next to the Semantic model field and re-select the model manually. Then click Refresh again in the table section to force metadata reload.

    * Ensure the model is fully published and not in a pending or draft state in Power BI especially if it's recently been modified.

    * As a temporary workaround, if you're not relying on selective table refresh, you can disable the table selection and let the refresh task operate at the full model level (by skipping table selection altogether). This is functionally equivalent to a full manual refresh.

     

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

    Best Regards,
    Hammad.

thedietplan's avatar
thedietplan
New Member
1 year ago

Same problem I had- manually type the tables by adding "objects": [{"table": "your table name"},{"table": "table name 2"}]

 

example for folks who will experience the same thing:

 

1. Go to view and clicked on edit json code

 

2. look for your semantic model refresh activity 

Sample: 

 

"name": "Semantic model refresh2",
"type": "PBISemanticModelRefresh",
"dependsOn": [],
"policy": {
"timeout": "0.12:00:00",
"retry": 0,
"retryIntervalInSeconds": 30,
"secureOutput": false,
"secureInput": false
},
"typeProperties": {
"method": "post",
"waitOnCompletion": true,
"commitMode": "Transactional",
"operationType": "SemanticModelRefresh",
"groupId": "your actual info",
"datasetId": "your actual info", 
"objects": [
{
"table": "name of table as it appears in powerbi"
},
{
"table": "name of table as it appears in powerbi2"
},
{
"table": "name of table as it appears in powerbi3"
},
{
"table": "name of table as it appears in powerbi4"
}
]

 

Hopefully that fixes it 🙂

 

Manny - PS

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi thedietplan,

Thanks for raising this and for sharing a solid workaround. You are absolutely right that this behavior feels like a regression. When the UI inside the Semantic Model Refresh task fails to list tables even though they exist and refresh works manually, it can break automation workflows and is definitely frustrating especially since it previously worked as expected.

You also mentioned a great point of having to manually refresh the table list every time you add new tables during development. Your idea to allow full model refresh without listing tables explicitly makes total sense and aligns with how most users expect this to work.

 

Best Regards,

Hammad.