Forum Discussion
Fabric pipeline error with semantic model
I am having real issues with fabric pipeline run and specially semantic model activity. It does not allow to refresh the model, because somehow it asks old structure. I had to clean and delete old tables and reuploaded the model with the report. It just did overwrite in the power bi service. But fabric acitvity does not recognise the change. I did try to make a NEW acitivity with new configuration but still same old error. "Table is missing". I try to select the tables to refresh but will get an error that connection to list tables not possible.
I also tried to edit the json for that pipeline, but there is no hint that it is selecting the tables. Just refreshing all dataset. But still somehow it remembers there was a table and now it is missing. How?
It succeeded
I created totally new pipeline and made a new activity. Then it worked.
5 Replies
It succeeded
I created totally new pipeline and made a new activity. Then it worked.
Hi stiggrr87 , glad to know your issue is solved and is really thankful to you for sharing the information here. If you have any other queries, please feel free to create a new post here in the community. We are always happy to help.
Hi stiggrr87 , Thank you for reaching out to the Microsoft Community Forum.
This usually happens because the pipeline activity cannot retrieve the current table metadata from the semantic model. The Semantic model refresh activity first tries to list the tables in the dataset (ListTables). If that call fails, Fabric cannot show the table list and you may see errors like “Table is missing” or “Could not connect to WebConnection – ListTables”. This often appears after the model structure changes (tables deleted or recreated).
The pipeline itself does not store the table structure, but it depends on the metadata returned by the semantic model in the service. If the dataset was overwritten or republished, the activity may still be pointing to outdated metadata. Reselect the semantic model or recreate the refresh activity, which forces Fabric to fetch the current schema again. Also confirm the dataset refresh works directly in Power BI Service, since the pipeline uses the same refresh APIs.
Hi stiggrr87 , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.
Hello,
Still the same. It cannot load the tables and gives ListTables error. I cannot select the tables. But it seems like the refresh itself is working. Seems like it is doing the full refresh if tables not selected.
