Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)

So, this one is an oddball one.

When I query a particular DQ dataset form Excel I get the error "Data seen at different points in time during execution of this query are inconsistent with each other. This could be due to external transactions updating same data while this query was running. Please rerun this query." However, the exact same setup querying the underlying dataset (the source for the DQ dataset, which is a typical import model) doesn't produce this error. 🤔

Tracing using Dax Studio, I find the underlying MDX query (which works when directly queried against the source dataset) is:

MDX Query:

SELECT 
    NON EMPTY 
        Hierarchize
        (
            AddCalculatedMembers
            (
                {DrillDownLevel({[Value Selector].[Value Selector].[All]})}
            )
        )
    DIMENSION PROPERTIES 
        PARENT_UNIQUE_NAME,
        HIERARCHY_UNIQUE_NAME
     ON COLUMNS
FROM [Model]
WHERE 
    [Measures].[Total Actuals NZD]
CELL PROPERTIES 
    VALUE,
    FORMAT_STRING,
    LANGUAGE,
    BACK_COLOR,
    FORE_COLOR,
    FONT_FLAGS;

Resultant DAX generated to the source dataset is (and when run in DAX Studio is working):

DAX Query 1:

EVALUATE
GROUPCROSSAPPLY(
    "__Agg0", [Total Actuals NZD]
)

DAX Query 2:

DEFINE
VAR _Var0 = VALUES('Value Selector'[Value Selector])
EVALUATE
GROUPCROSSAPPLY(
    'Value Selector'[Value Selector],
    ALLSELECTEDREMOVE(_Var0),
    "__Agg0", [Total Actuals NZD]
)

DAX Query 3:

EVALUATE
SUMMARIZE(
    VALUES('Value Selector'),
    'Value Selector'[Value Selector],
    'Value Selector'[Order]
)

The model structure is simple enough - although not the best modelling setup. The measure used is a simple column sum...

Not sure where to go from here? 🤷‍