Change directquery to import error?

You're welcome 🙂
Ah - that explains it then.

When you use DirectQuery with Analysis Services or Power BI datasets within a Composite Model (as described here), the tables from the "remote datasets" cannot be switched to Import mode.

The idea of connecting to datasets in this way is that you are connecting to a "model" rather than individual tables, inheriting all features of the remote model, and the tables remain remote and are not imported into the local model.

If you wanted to import a table from an Analysis Services dataset, you would need to instead use the Analysis Services connector and select Import (Get Data > Analysis Services and select Import).

This should work with any Analysis Services dataset, but would only work with Power BI datasets with XMLA endpoints enabled (requiring Premium).

However it is generally considered better to connect to the underlying data source than importing from Analysis Services, but there may be specific reasons you need to do it this way.

Regards,

Owen