Import filtering by some fields

[Carlospa]

Hi All
I wanna be able to import data from my database, but filtering  by some field, p.e. "FECHACREACION" 

Example if i importa table "GCFacturas_BI" i usually import data with this commands

let
Origen = Odbc.DataSource("dsn=4D 64 bits", [HierarchicalNavigation=true]),
GCFacturas_BI_View = Origen{[Name="GCFacturas_BI",Kind="View"]}[Data]
in
GCFacturas_BI_View  

I only want to import data whose creation FECHACREACION is greater than 01/01/2022
Thank you in advance

[v-yalanwu-msft · Accepted solution]

Hi, @Carlospa ;

I tested by sql service:

if i connect by basic:

let
    Source = Sql.Databases("wx-89356"),
    table = Source{[Name="table"]}[Data],
    dbo_test = table{[Schema="dbo",Item="test"]}[Data]
in
    dbo_test

When I connect advance :

let
    Source = Sql.Database("wx-89356", "table", [Query="select * from family where FamilyID !='F001'"])
in
    Source

The final show:

Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ImkeF]

Hi @Carlospa ,
many ODBC sources fold, so I'd just try to apply the filter as the second step and check if it just returns the filtered data.