Forum Discussion

lavanyak's avatar
lavanyak
Advocate I
7 years ago
Solved

Limiting Rows while Exporting from SQL Server

Hi,

could someone please help me how to limit the rows while importing data from sql server?

 

Thanks in advance!

Regards

Lavanya

 

Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Hi lavanyak,

     

    You can use SQL statement to filter rows when you import data from sql server.

     

    Regards,

    Jimmy Tao

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Hi lavanyak,

     

    You can use SQL statement to filter rows when you import data from sql server.

     

    Regards,

    Jimmy Tao

    • lavanyak's avatar
      lavanyak
      Advocate I
      7 years ago

      Yes, Thankyou I got how to do it through Mcode in power query.

       

      Thanks for your response.