Having PowerBI reading a token from text file to be used in a web source

[ciampa]

Hi all,
I need to connect to a REST web source that supports only Anonymous connection and needs the token to be inserted as "Authorization" HTTP Header. I'd like though to make this token external to the Power BI desktop file, so that it'd be shared to other colleagues or clients in a safer way.
I've seen how to find the token within the power query  > Advanced editor but even looking in this forum i'd not find a detailed  example script on how to read that info from an external file.

any help is greatly appreciated.

many thanks in advance

[PhilipTreacy]

Hi @ciampa 

If you just need to read a value from an external file you can do this using any of the relevant connectors e.g.

Get Data -> Excel Workbook

Get Data -> Text/CSV

regards

Phil