Import query to get less data

[JoseHop]

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 of time to get the data. 

(don't get it at all) 

It a table with rows per date. So I only want the rows after december 2015. 

How do I do this?

[grazitti_sapna]

Hey,@JoseHop 

If you want to limit the number of rows while importing the data.

You can Click on the ‘Advanced option’ to expand the options.

In SQL statement you can enter the custom query that is 

Select * from table_name where date >= ‘2016-01-01’

**Do mention the database name above 

Hope this will help.

[JoseHop]

Hi @grazitti_sapna 

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?

[grazitti_sapna]

Hi @JoseHop 

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.

[JoseHop]

hi @grazitti_sapna , I keep getting mistakes: