Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
I only want to import data whose creation FECHACREACION is greater than 01/01/2022
Thank you in advance
Solved! Go to 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.
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.
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.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |