Import filtering by some fields

Question

Hi AllI wanna be able to import data from my database, but filtering&nbsp; by some field, p.e. "FECHACREACION"&nbsp;Example if i importa table "GCFacturas_BI" i usually import data with this commandsletOrigen = Odbc.DataSource("dsn=4D 64 bits", [HierarchicalNavigation=true]),GCFacturas_BI_View = Origen{[Name="GCFacturas_BI",Kind="View"]}[Data]inGCFacturas_BI_View&nbsp;&nbsp;&nbsp;I only want to import data whose creation FECHACREACION is greater than 01/01/2022Thank you in advance

v-yalanwu-msft · Accepted Answer

Hi,&nbsp;Carlospa&nbsp;;
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

&nbsp;
The final show:

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

Forum Discussion

Import filtering by some fields

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

2 Replies

Related content

Importing a Lookup Field

Converting Epoch Date fields within the import statement

Import files filtered by preferences

Filter Field Parameter by Field Parameter Values without Calculated Groups

Measure with multiple filters on same field