Forum Discussion

Ha_Da's avatar
Ha_Da
Frequent Visitor
9 years ago
Solved

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 mappin...
Need Help
  • Vicky_Song's avatar
    Vicky_Song
    9 years ago

    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.

Ha_Da's avatar
Ha_Da
Frequent Visitor
9 years ago

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

Senbahrs's avatar
Senbahrs
Frequent Visitor
9 years ago

 

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.