API excel and PB

[Mart1980]

Hello all,

i have an API connection from a tool to power bi which basically has in the code all the certain keywords that i need information for. Now i also have an excel sheet that I basically input keywords that are relevant. I was wondering if there is a way to lookup to the excel sheet for keywords and then update the api code automatically with the added keywords. Is this a possibility?

[lbendlin]

yes,  with caveats - you will awaken the formula firewall monster.

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?