Excel Source to Query SQL database

[jsit]

Hi,

Newish to Powerbi, I've used WEBI SAP BI and can use an Inlist query. What is the equivalent in PowerBI?

The question is?

There is an Excel Table with around 400 PO (Purchase Orders, PO ) in a column which I would like to use to query a SQL database with around 10,000,000 entries.

The spreadsheet is manually edited with a PO, and would like to use these PO's t oquery the SQL Database.

What is the best method to acheive this, obvioulsy I could use merge, however that requires loading the full 10m entries.

Any suggestions and help greatly appreciated.

Regards

Glyn

[v-priyankata]

Hi @jsit 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-priyankata]

Hi @jsit 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-priyankata]

Hi @jsit 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Akash_Varuna]

Hi @jsit Try these please 

• Load Excel Table: Import the PO list into Power BI.
• Native SQL Query: Use a native SQL query with an IN clause to filter data at the source.
• Dynamic Query: Construct the query using Power Query M functions to pass Excel POs dynamically.
• Optimize: Ensure query folding and indexing on the PO column for better performance.
  If this post helped please do give a kudos and accept this as a solution
  Thanks In Advance