apply the data filter when the data are load in the power bi

[Anonymous]

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

[v-piga-msft · Accepted 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

[Anonymous]

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