Forum Discussion

Carlospa's avatar
Carlospa
Regular Visitor
3 years ago
Solved

Import filtering by some fields

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 ...
General Comment
Need Help
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    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.

     

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

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.