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

[scrubyl]

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

[scrubyl · Accepted solution]

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

[Anonymous]

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.

[cannoli]

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?

[scrubyl]

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

[GilbertQ]

Hi @scrubyl 

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

[scrubyl]

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