Pull data from SQL Server based on Excel Query

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.

Example:
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.



Read more here: https://stackoverflow.com/questions/64406171/pull-data-from-sql-server-based-on-excel-query

Content Attribution

This content was originally published by Bryan Copus at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: