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
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