Forum Discussion

palmeirense_'s avatar
palmeirense_
Frequent Visitor
5 years ago

How to connect to only one table from PBI dataset (Direct Query) ?

Hi,   I am working on a model where I am combining multiple datasets using direct query. I am on dataset #1 right now and for what I am trying to accomplish, I only need 2-3 tables from dataset #2...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, palmeirense_ ;

Do you mean that use DirectQuery to connect to Azure Analysis Services or Power BI Datasets as sources, and conect only some tables in one dataset, not all tables? 

 Based on my understanding, it doesn't work. A dataset is a whole.

https://powerbi.microsoft.com/en-us/blog/power-bi-december-2020-feature-summary/#_Toc58831296

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.