Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

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": [
          "    Source = AnalysisServices.Database(\"powerbi://\", \"NewModel\"),",
          "    Cubes = Table.Combine(Source[Data]),",
          "    Cube = Cubes{[Id=\"\", Kind=\"Cube\"]}[Data]",
          "    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).



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:



Community Support
Community Support

Hi @Anonymous ,


If you still cannot solve the issue,sorry for that, I do not found an effective solution.🤔
You could go to ,scroll down and click "CREATE SUPPORT TICKET" for further help if you are a pro user.


Best Regards,
Eyelyn Qin

Community Support
Community Support

Hi @Anonymous ,


Could you please delete the All perspective to have a try again?

And please always use the latest version of PBI.


Refer to: 

Perspectives in tabular models

Let users personalize visuals in a report - Power BI | Microsoft Docs


Best Regards,
Eyelyn Qin

Not applicable

Hi @v-eqin-msft , 


Thanks for your reply.


I've tried both: updating to the latest version and removing the other perspective. I get the same results. 


Are you able to reproduce the issue with a different outcome?

Not applicable

The relevant Microsoft documentation: 

"When connecting to a Power BI dataset or Azure Analysis Services model using a DirectQuery connection, you can decide which tables to connect to. You can also choose to automatically add any table that might get added to the dataset or model after you make the connection to your model. Note that when you connect to a perspective your model will contain all tables in the dataset or model and any tables not included in the perspective will be hidden. Moreover, any table that might get added to the perspective will be added automatically. This dialog will not be shown for live connections."



Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors