Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
palmeirense_
Frequent Visitor

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. Is it possible to bring only the revelant tables into my model?

I have only been able to import the entire dataset, which is unneccessarily impacting performance.

Thanks!

3 REPLIES 3
JoachimSA
Helper II
Helper II

I am also looking for this kind of functionality!
I only need one "result" table for each of several different source data sets to compare them in my "Master Comparison" Power BI file.

Right now I create this "result" table for each Dataset as a visual within Power BI Desktop and export the data to CSV.

This is not very efficient because of the lack of compression and the normalized form of the data.

Right now I am thinking about moving this step to Dax Studio: Using Summarizecolumns I create my result table in the granularity I need and export it as .xls . This at least does some compression on the data. I then import all those Excel into the Master Comparison.
The best solution would be to do this DAX Query into each source PBIX or online Data Set from within my Master comparison. It is my understanding that with direct query for power BI data sets you always import the whole model as you pointed out. THis gets very messy when you have several source data sets.
HOw perfect would it be to have some kind of data flow that can use DAX query to pull together data from different PBIX / Datasets ?!

Okay, so I think i found the solution! 
If you try to load the Data Set into an EMPTY Project it will automatically load ALL the tables in the remote data set.
However, if you have one existing table already as a local model it will ASK you which tables you want to import!
Now my problem is: How can I get back to that table selection if i found out after the fact, that I forgot one ?

v-yalanwu-msft
Community Support
Community Support

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.