Composite Data Model Not Refreshing in Service

[j_ocean]

I have a composite data model that refreshes fine in Desktop PBIX but refuses to refresh in Service. The error received is "internal service error," that is "usually transient" but has been going on for about a week.

[edhans]

Either need more info, or you should open a support ticket at Microsoft Fabric Support and Status | Microsoft Fabric

[j_ocean]

What other info are you expecting? Since it works fine in Desktop it's not a coding or model logic issue, is there a setting? Is refreshing composite models in Service not supported?

[edhans]

Yes, it is supported in the service. But what kind of composite model?

• Import + DirectQuery of a relational database?
• Import + DirectQuery of AAS/PBI datasets?
• DQ of AAS/PBI Dataset + DQ of relational database?
• two or more DQ of AAS/PBI Datasets?
• 2+ DQ of AAS/PBI Datasets + import table?

Lots of configs. What are you expecting to refresh? If it is DQ of AAS/PBI, how many connections are there? Is it Dataset A to Dataset B to Dataset C? 

[j_ocean]

One import table from PBI Dataflow.

Two DQ on PBI datasets.

Multiple DAX calculated tables using those dataset DQ tables.

[edhans]

Calcualted Tables aren't supported for refresh. Use composite models in Power BI Desktop - Power BI | Microsoft Learn

You should query those tables using the AAS connector and bring them in as Power Query Import tables.

[j_ocean]

If that's the cause why am I receiving a different error message?

[Brunner_BI]

You should also get this warning if you have calculated columns/tables that would create problems.