Forum Discussion
Composite Data Model Not Refreshing in Service
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 ...
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?
One import table from PBI Dataflow.
Two DQ on PBI datasets.
Multiple DAX calculated tables using those dataset DQ tables.
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.If that's the cause why am I receiving a different error message?
You should also get this warning if you have calculated columns/tables that would create problems.
