cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shakeelsyed Regular Visitor
Regular Visitor

Importing data with latest records

Hi, 

 

In a schema I have 200+ tables in SQL, approx. +5million records in it and I would want to import only top 100 records from all these tables into power bi desktop and create 200+ tables. Is there any possibility to do so?

 

Thanks

Shakeel

5 REPLIES 5
prakash11440278 Regular Visitor
Regular Visitor

Re: Importing data with latest records

Try to Insert required field (Normally by Date) in Report level filter and use the Relative filter as input Top N = 100

 

 

akafuma New Member
New Member

Re: Importing data with latest records

Importing data with latest records - This post is really important ! It plays an very important role in our daily life in every type of business . whether it is small sacle business or large scale business.
here you get related inforamation with complete guigance  here  - 
Acer Support

shakeelsyed Regular Visitor
Regular Visitor

Re: Importing data with latest records

Thanks for your quick reply!

 

in that case, I will be able to load only one table at a time, whereas I want to upload all 200+ table at once to avoid duplication of work.

 

Thanks

Community Support Team
Community Support Team

Re: Importing data with latest records

Hi shakeelsyed,

 

Click Advanced options-> input the sql statement to import top 100 records in every table.

Capture.PNG 

 

Regards,

Jimmy Tao

shakeelsyed Regular Visitor
Regular Visitor

Re: Importing data with latest records

Thanks Jimmy Tao,

 

I have tried that way but its only taking data from the last query and creating only one table with it. any other trick to do so?

 

image.pngAdvance Options Screenshot