Requesting TOP 5000 Rows from SQL Database

[Anonymous]

Hi! 

i have a problem i cant solve without your help.

I am connecting to a SQL Server where i need data from 2 large databases.

Both of them have a column with a time stamp (only date). Now i just want to querry the data from the last 2 Days - that means like 5000 rows filtered per Date.

I know i could import all data and then using power querry to sort and select top 5000 but then all the data gets extracted during the import. Is there an option to directly do it as SQL command? 

Like: Select Top 5000 * from database XY? Would it then be neccessary to sort it in the SQL database?

Really appreciate your help!

BR

Fabian

[v-yalanwu-msft]

Hi， @Anonymous ;

Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,

Community Support Team_ Yalan Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

You could connect Sql server by connecting using advanced options. 

Then if you need a 5000TOP import for both databases, you can split it into two write SQL statements in one .pbix .

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HotChilli]

I've not tried a cross-database query.  Is it the same server?

I suggest you experiment with your sql in SSMS and get it to work (I think it should be possible) then put it in Power Query and fire up sql profiler to see if the query passes through correctly

[HotChilli]

When you start a new query-> SQL Server, the dialog has a section    ->SQL statement (optional)

[Anonymous]

Thank you. And can i also use a SQL command there to sort the SQL database based on the date column? And can i just write the statements one to the next because i retreive data from two databases?

 or do i need to create a second querry?