Forum Discussion

scrubyl's avatar
scrubyl
Frequent Visitor
1 year ago
Solved

Semantic Model refresh fails due to COM error: Parquet, cannot find data type handler to create mode

Hello,

 

I get the following error on refresh which has stopped my model refreshing

COM error: Parquet, cannot find data type handler to create model schema for [n: stats_parsed, t: <not set>, ct: <not set>, rt: OPTIONAL, c: 0]. Table:

 

The underlying data is refreshing okay but for some reason the models created off of the lakehouse have began failing - These have been working for well over a month with no issue

When i try to create a model or take tables out and put them back in i get an error also see below:

 

COM error: Parquet, cannot find data type handler to create model schema for [n: stats_parsed, t: <not set>, ct: <not set>, rt: OPTIONAL, c: 0]

 

 


How do i resolve as I cannot rebuild the model each time this happens as this is running a live customer report

  • This issue has been resolved internally aside from msft support - renaming the tables in the orginal model triggered a refresh to the endpoint which meant it worked again

6 Replies

  • scrubyl's avatar
    scrubyl
    Frequent Visitor

    This issue has been resolved internally aside from msft support - renaming the tables in the orginal model triggered a refresh to the endpoint which meant it worked again

  • Hi scrubyl 

     

    Could I ask why you dont use the SQL endpoint for the Delta Tables in your Lakehouse?

    • scrubyl's avatar
      scrubyl
      Frequent Visitor

      We do use an SQL endpint but i use the lakehouse to generate the semantic models

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi scrubyl ,

    Based on the information, this issue has been identified as a known issue and the issue has been resolved and you can try it again.

     

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • scrubyl's avatar
      scrubyl
      Frequent Visitor

      Unfortunately, this is still not working - I have a ticket raised and has been escalated to the PG team but for now the refresh or adding any tables into a semantic model remains broken

    • cannoli's avatar
      cannoli
      Frequent Visitor

      Has this issue been resolved? I am currently experiencing the same error for two of my tables when trying to create a semantic model. Are there steps I can follow to fix this?