Need to apply condition during importing the table data using ODBC connection

[SantoshKumar]

Hi,

I am importing a table data to power bi using ODBC connection.

i am able to fetch data without any issue. in order to get my required data i need to apply a condition on one of the column like below

select *

from table1

where column_tags contains ("ABC", or "XYZ")

here - i want to apply filter during importing the data into my power bi.

so, i need only data to show in my reports which has words like "ABC" or "XYZ" in column called as TAGS.

Thanks

Santosh

[SantoshKumar · Accepted solution]

I worked on it and i have got the solution.

During connection there will be an option to provide query.

i have provided my query and i got my resulted data.

Thanks

Santosh Kumar