Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

" is not understood

Small issue with " in power query
i have a parameter for Datacenter - and it is passed into this line of my power query

vBaseUrl = "https://" & Datacenter & ".mycompany.com",

works perfect

 

I want to have a parameter for apikey, but I can't figure out, how to do that.
This is my working code:   vHeaders = [ #"apikey"="xxxxxxx"],

How do i replace the xxxxxxx with a parameter? I tried
vHeaders = "[ #"apikey"="" & parameterapikey & ""]",

 

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    This did the trick for me

    vHeaders= [#"apikey" = apikey ],

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    This did the trick for me

    vHeaders= [#"apikey" = apikey ],