I have a PowerBI report I am currently working on where I would like to use an existing query from an Excel file to pull specific data from a database on an SQL Server.
Excel file has column named "Order" and is limited to 60 rows.
SQL server has an "Order" and "Sales" column and has 4 million rows.
I would like to query the SQL server to only retrieve rows that match the 60 rows in my excel file.
I feel like this is something that is probably very simple and I'm overlooking it.