Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Import and DirectQuery (at the same time)

Hi Folks,


I am trying to find the best way to go about doing this with PowerBi.  Currently connected to our EDW which houses all the order/line item/etc information.  I have a list of 30 unique sales order numbers that I want to retrieve information for that is housed on the EDW.  However, my PowerBi reporting file is in directquery mode (importing all of that data would be too large).  


Is there no way to Import an excel file into PowerBi, make a relationship between that dataset and the DirectQuery data set?  


Maybe I am thinking about this the wrong way.  




Current version of Power BI doesn’t allow to use Import and DirectQuery at the same time. If you want to retrieve information of the 30 unique sales, you need to make this list table to be in the same database which holds all the order/line item/etc information.


Please refer to here for limitations of DirectQuery. You can also vote this idea (allow Import and DirectQuery at the same time) here.



Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors