DataCoverageDefinition not taken into account. Tabular Editor fails to connect after deploying model.

[HennySpeelman]

Description:
Fail to re-connect to deployed model after altering the datacoveragedefinition property on a direct query partition of my fact table in the semantic model. Property doesn't seem to be available when opened with SSMS.

Here are my actions:
I first created a data model in Power BI with a fact table (DirectQuery mode).
Then I published this to a premium workspace.
I connected to this model with TE2.23.0 -> this works

• Changed the compatibility mode to 1603
• Duplicated partition of the table I want to make hybrid
• Changed the data storage mode of the new partition to 'import'
• Changed the names of the partitions (DQ and import)
• For the DQ partition, I added the 'datacoveragedefinition': 'FactTable'[Date Key] < 20230101
• I published this model -> this works
• I close Tabular editor and reopen it
• I get the error 'This object does not have any child collections' (error connecting to database)

I would have expected to be able te reconnect and check whether the property was there.
When checking the query optimizer in Power BI desktop (with a live connection to the published data model), I still see a DAX and Directquery, so I assume the property is not deployed correctly. Deploying this option via SSMS also does not work. (succesful commit, but property nowhere to be found after deployment)

Compatibility level:

Import partition:

Direct Query partition:

Error:

[otykier]

Thanks for reporting this. I was able to reproduce the issue when re-opening the model in Tabular Editor, and have just published an updated version where this is fixed: https://github.com/TabularEditor/TabularEditor/releases/tag/2.23.1

[HennySpeelman]

Great! it works.

Thanks for this lightning fast solution.