Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
JoseHop
Helper I
Helper I

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?

4 REPLIES 4
grazitti_sapna
Resolver I
Resolver I

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.

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?

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.

hi @grazitti_sapna , I keep getting mistakes:

JoseHop_0-1686127381655.png

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.