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.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

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