Forum Discussion

shakeelsyed's avatar
shakeelsyed
Icon for Helper I rankHelper I
7 years ago

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 ...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi shakeelsyed,

 

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

 

 

Regards,

Jimmy Tao

shakeelsyed's avatar
shakeelsyed
Icon for Helper I rankHelper I
7 years ago

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