Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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.
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 @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.
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |