Import data only for values in a different table

[Chetanab]

Need help - I have a table with a column called IDs in Power BI. This is an excel list. I need to obtain corresponding status column for these IDs from a table in a different database. The issue here is that this is a very large table and I cannot import all of this data into PBI. Is there a way to parameterize the column from Excel to obtain status values from the database only for the IDs in the Excel?

[Chetanab]

This solved the problem - Solved: Using a list as a parameter of an SQL query - Microsoft Power BI Community

[Chetanab]

It's a single column. My query should achieve something like this- select status from tbl1 where ID in (/*IDs from excel list*/)

[mohammedadnant · Accepted solution]

Hi @Chetanab 

Is the IDs column multiple columns or single in excel.?

if you have a single column you can convert this excel column into a list and pass as a filter parameter to the other data source.

Pls refer this video for concept: https://youtu.be/ojSQqe2eqx0

Thanks & Regards,

Mohammed Adnan

Learn Power BI: https://www.youtube.com/c/taik18