Forum Discussion
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 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?
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
3 Replies
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*/)
This solved the problem - Solved: Using a list as a parameter of an SQL query - Microsoft Power BI Community
