Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Invalid Literal error while passing parameter in advanced query editor

Hi   I am new to Power BI, i searched in power BI forum and tried multiple times but still getting error so posting here.   I am executing simple select statement using parameter but getting inva...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    To update your M code in Power query as below.

     

     

    Spoiler
    let
    Source = Sql.Database("advt.database.windows.net", "advt", [Query="select * from stg.emp #(lf)where EMPID = #"empid"])
    in
    Source

    Regards,

    Frank

     

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

To update your M code in Power query as below.

 

 

Spoiler
let
Source = Sql.Database("advt.database.windows.net", "advt", [Query="select * from stg.emp #(lf)where EMPID = #"empid"])
in
Source

Regards,

Frank