Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ...
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
@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
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 ?
Also, I don't restrict using powerquery, i meant restrict the data using slicers
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |