Passing Parameters/Variables in Advanced Editor and R Script (e.g. Facebook Tokens)

[FrugalEconomist]

Dear Community,

I routinely pull insights data from our institution's facebook page. This involves updated the page access token each time. As I have 3~4 queries, it's a kind of a minor pain to have to manually replace the FB token each time.

Is there a way to declare the token and have it passed through or stored as a variable to be used in each query?

I've shared my code snipped (used Rfacebook package because I think PowerBI has unfortunately abandoned their canned facebook connector 😠 .... 

Thanks.

[parry2k]

Yes you can do this, create a paremeter by following steps:

- click edit query

- click manage parmaeters and add new parameter lets' call it Facebook Token

in advance editor, replace your token value with your parmater like this #"Facebook Token"

[FrugalEconomist]

Like this?

Does it need the hashtag?

[parry2k]

Yes it does, do you have space between your parmater name or not? It exactly matches with your parameter name,

[FrugalEconomist]

No I named my parameter without the space. 

I tried it with a tail hashtag too 😞

Maybe it doesn't work in RScript? 😞

This is the RScript Error:

Error in callAPI(url = x, token = token) :
argument "token" is missing, with no default
Calls: getInsights -> lapply -> FUN -> callAPI
Execution halted

[parry2k · Accepted solution]

sorry i was not aware it is a R query, here is another post on this forum. hopefully it is helpful.

https://community.powerbi.com/t5/Integrations-with-Files-and/How-to-pass-query-parameter-to-Data-Que...