Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...
Need Help
grazitti_sapna's avatar
grazitti_sapna
Super User
3 years ago

Hey,Anonymous 

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      grazitti_sapna
      Super User
      3 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        hi grazitti_sapna , I keep getting mistakes: