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.
Hi all,
I'm connecting in Power BI throught Oracle Database. So I want apply the data filter when the data are load in the power bi. The goal is load a small number of data so that the charging is faster. These it's possible?
Thank you.
Regards,
Vanessa Casaca
Solved! Go to Solution.
Hi @Anonymous,
Yes, it is possible for us to apply the data filter when the data are load in power bi.
You can add your condition formula to advanced option -> sql statement or filter them in query editor.
Here are some similar threads for your reference:
Pre-Filtering Data before Importing
Filetring my table before importing in PowerBi
Oracle DB: Import data for specific date range
Best Regards,
Cherry
Hi @Anonymous,
Yes, it is possible for us to apply the data filter when the data are load in power bi.
You can add your condition formula to advanced option -> sql statement or filter them in query editor.
Here are some similar threads for your reference:
Pre-Filtering Data before Importing
Filetring my table before importing in PowerBi
Oracle DB: Import data for specific date range
Best Regards,
Cherry
Hi @v-piga-msft,
Thank you for your help.
Your solutions are right. I discovered that you can also filter the data throught parameters.
Do you know how to change the parameters throught visual in Power BI?
Thank you very much.
Best regards,
Vanessa Casaca
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |