Importing data with latest records

[shakeelsyed]

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

[v-yuta-msft]

Hi shakeelsyed,

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

 

Regards,

Jimmy Tao

[shakeelsyed]

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?

Advance Options Screenshot

[akafuma]

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

[prakash11440278]

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

[shakeelsyed]

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