Store/insert API tokens for automatic refresh with Python

[benjikj_mcsp]

Hi,

I have written some Python to pull data back from an API using access tokens that need refresh tokens after so long.

This works fine running locally on my machine with the tokens stored in json files where the Power BI Desktop file is stored, but I'm wondering how I might automate this so I can refresh everyday within PowerBI instead.

My main concern is how to store credentials securely, as opposed to hard coding anything into the Python script.

Any suggestions? I have never used the gateway connections or anything, so not sure how they really work, or if they'd work, but wondering what the options are.

Thanks,

Benji

[Anonymous]

@benjikj_mcspCan you share this python script, I am struggling with this problem at the moment.

[Greg_Deckler]

Should be fine, you could store the json files some place that the gateway could access them or even in Azure blob storage if you want to be fancy.

Python is my new favorite programming language! 🙂

[benjikj_mcsp]

But do I have to use a Gateway?

With any blob storage, or AWS/S3 or anything, wouldn't I need to store the credentials for that access somewhere, not hardcoded, to make it secure?