An error occurred while processing the data in the dataset

[threepin]

I had a report published on the Power BI Service and was running fine but the Power BI Dataset started failing with the below error:

MyReport has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support. 
{"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}}}
Next refresh for MyReport is scheduled for February 23, 2023 22:00 UTC.

There are no calculated tables or columns in my model.

The refresh also works fine on Power BI Desktop. I'm using a composite model with one import table and one Directquery table. Wondering if anyone can give some guidance on the error and how to fix this?

[AnkitKukreja]

Hi @threepin 

If you don't have any Calculated tables or columns then can you check if you are hitting any other limitations or if the settings are turned on correctly as suggested in the doc.

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-...