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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.