Forum Discussion
Solved
Import data only for values in a different table
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...
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
It's a single column. My query should achieve something like this- select status from tbl1 where ID in (/*IDs from excel list*/)