Forum Discussion
MNMKJ
2 years agoFrequent Visitor
Filter of data while importing from sql
Hey Guys, Need help with below: I have a huge data set in hadoop which i have connected with power bi. I also have another table in excel which contains list of customers i need to filter and ...
amitchandak
2 years agoSuper User
MNMKJ , I think it should be like
let
Source = Odbc.Query("dsn=impala", "SELECT * FROM analytics_n_reporting.v_lpm_smth_liab_consld_acct_details WHERE cod_cust_id IN ('kadam')" )
in
Source
MNMKJ
2 years agoFrequent Visitor
Hey, it is not working as single quotes does not takes parameters. please help here