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?
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.