Forum Discussion
Get data with Direct Query and Import Data
Hi All,
Recently I am designing a new report in Power BI Desktop. As its data is too big, I load data from Oracle database using Direct Query. After that I realized that I need to Get some mapping data from Excel. But Excel only support Import data mode. If I switch whole report to Import data mode, it will spend a lot of time in loading and refreshing data from database. Is there any way that support both get data method? Is there any solution for this condition? Thanks in advance.
Ha Da.
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.
6 Replies
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.
