Power BI dataset DirectQuery Perspective not limiting tables

By using the preview feature ‘Directquery for PBI datasets and AS’ I am able to select a perspective when connection to a Power BI Dataset. The model and it’s perspectives are created using Tabular Editor. The perspective NoCustomer does not include the customer table.

When selecting the perspective and loading the data all tables show up. This includes the table that is not included in the perspective.

The underlying .bim file has no reference to the perspective (where I would expect it)

{
        "name": "DirectQuery to AS - NewModel",
        "kind": "m",
        "expression": [
          "let",
          "    Source = AnalysisServices.Database(\"powerbi://api.powerbi.com/v1.0/myorg/XXX\", \"NewModel\"),",
          "    Cubes = Table.Combine(Source[Data]),",
          "    Cube = Cubes{[Id=\"\", Kind=\"Cube\"]}[Data]",
          "in",
          "    Cube"
        ],
        "lineageTag": "3....",
        "annotations": [
          {
            "name": "PBI_IncludeFutureArtifacts",
            "value": "True"
          }
        ]
}

Is this a bug or am I missing a vital step in the process? 😉

The dataset runs on a Power BI Premium Per User Workspace. The Power BI Desktop version is 2.99.862.0 64-bit (November 2021).

Steps

1.Check Settings:

2. Start with a PBIX file with a connection to a local XLSX:

3.Add connection to a Power BI Dataset:

4. Choose perspective:

5. Cross check perspective settings in Tabular Editor:

6. Expected result in Power BI Desktop: only SalesLT SalesOrderHeader is loaded into the model. SalesLT Customer should not be included. Actual result: both tables are included: