Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Oracle and power bi

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 ...

 

Need Help

5 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        Anonymous
        Not applicable
        6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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