Forum Discussion

dsamar's avatar
dsamar
Advocate I
10 years ago

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 s...
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
10 years ago

dsamar

 

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.

 

Regards,