Oracle and power bi

[Anonymous]

I have a view in Oracle which has several thousands of rows (possibly millions), my power bi report has filters
which will control this

Question: My understanding is, the first step of building a power bi report is to load the dataset..is loading the dataset same as loading the ENTIRE data from the view or whatever is the source ?
Meaning, when I first define the source and specify my "select * from view" in power bi desktop...when the screen shows "loading"..does power bi desktop
loads the entire data in the view for the report I am about to build ? Sometimes the loading takes forever and I am wondering what is going on ...

[Anonymous]

To connect to an Oracle database with Power BI Desktop, the correct Oracle client software must be installed on the computer running Power BI Desktop. The Oracle client software you use depends on which version of Power BI Desktop you've installed: 32-bit or 64-bit. Supported Oracle versions: Oracle 9 and later.

I hope this helps!

Admin

o365cloudexperts

[az38]

@Anonymous 

if you filter data in PowerQuery, its better to use filter in PL/SQL statement like select * from view WHERE....

Usually, view has some code and programmatic inside it and it could be a reason of long execution

[Anonymous]

So that means the entire data is loaded into dataset ? Which is why its better to give where conditions and restrict the source data so power bi won't choke ?

[Anonymous]

Also, I don't restrict using powerquery, i meant restrict the data using slicers 

[az38]

@Anonymous 

my personal experience - if you do not need data in your report - do not import it and try to cut off excessive data in data source statement
if you will filter data in report mode - your report still will work with all huge amount of rows and columns that was imported