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 there any possibility to do so?

 

Thanks

Shakeel

Need Help

5 Replies

  • prakash11440278's avatar
    prakash11440278
    Icon for Post Prodigy rankPost Prodigy
    7 years ago

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

     

     

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

      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

  • akafuma's avatar
    akafuma
    New Member
    7 years ago

    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

  • 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