Forum Discussion
Import query to get less data
hi there, I probably have a simple question. But I can't find it in the forums so far. I want to get data from a SQL database. The table contains a lot of rows I don't need and its taking a lot...
Thnx for your quick reaction.
I tried:
let
Bron = Sql.Database("sqlsrv-group-prd-datawarehouse.database.windows.net", "sqldb-group-prd-flexkids"),
dbo_VW_FACTUUR = Bron{[Schema="dbo",Item="VW_FACTUUR"]}[Data],Select * from VW_FACTUUR where FACTUUR_DATUM >= ‘2016-01-01’
in
dbo_VW_FACTUUR
somehowe it doesn't accept *
Do you know what is wrong?
Hi Anonymous
Your Welcome.
You can try using evaluate instead select in you SQL query.
let
Bron = Sql.Database("sqlsrv-group-prd-datawarehouse.database.windows.net", "sqldb-group-prd-flexkids"),
dbo_VW_FACTUUR = Bron{[Schema="dbo",Item="VW_FACTUUR"]}[Data],
FilteredRows = EVALUATE dbo_VW_FACTUUR
where FACTUUR_DATUM >= DATE(2016, 1, 1)
in
FilteredRows
Thank you. Hope this will help.