Forum Discussion
Get data with Direct Query and Import Data
Ha_Da, I'm sorry for the issue you got. I think you already figured out that it is impossible to get data with mix mode in Power BI, that is, you can choose either Import or Direct Query, but not both. So, for your scenario, you have to switch to the Import mode; or try to migrate excel data to Oracle first and then get data with the Direct Query mode in PBI.
Yes, I read a tech note from Power BI Instruction yesterday about direct query. Sinse figuered out there is no way to load data with both way, I am investigating advanced option to reduse data from databse, I have to redesign my working tool if I want to import my Excel data to Oracle database. Thank you anyway.
Ha Da
Sir, in such cases may be you can try relying on Views.
Create a SQL view to load the excel data on the direct Query data base and do access that view from Power BI via the same source.
Hello,
Has anything changed? Is it still impossible to have both Direct Query and Import in the same report?
