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 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?

Need Help

4 Replies

  • 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.