Failed to refresh combined model

[masplin]

Hi

I have 2 models published out on the service. One automatically refreshesevery 2 hours as all the data comes from Microsoft dynamics . The other one is done weekly using downlaoded spreadhseets, refreshed in desktop them published out

I created a combined model using the get data Power BI datasets. This model works fine refreshing in desktop, but once published othe service it is just dead in the water. I assumed it woudl pic up changes to the other 2 models automatically?

Instead i get this error if I try to manaully refresh it. I dont understrand the point of combined modles if the data doesn't update?  Can anyone explain as doesn't make sense to me?

Thank for any advice

Mike

Data source error:	{"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"Refresh is not supported for datasets with a calculated table or calculated column that depends on a table which references Analysis Services using DirectQuery."}}],"exceptionCulprit":1}}}
Cluster URI:	WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net
Activity ID:	f1b9089d-36a0-4b8f-ab56-b1fa41a2f95e
Request ID:	627aed45-9579-4eeb-8826-e11f34c50d81
Time:	2023-02-17 19:50:53Z

[GilbertQ]

Hi @masplin 

This is not working because you cannot have a calculated table or column which is connected to another dataset which is using DirectQuery.

What it appears is that your dynamics model is using DirectQuery which is causing the error when combining the datasets

[masplin]

There doenst seem any choice but to use direct query.   so once you have combined your datset you can use measures, but not calcuated columns/table in the new combined model?  It apears the data has started updating if I just hit refresh the webpage it picks up latest from the 2 underlying models so maybe it doens't need refreshing. Wasnt sure how a combined modle got updated.