topic Re: Store/insert API tokens for automatic refresh with Python in Report Server

Store/insert API tokens for automatic refresh with Python

benjikj_mcsp — Thu, 14 May 2020 20:59:36 GMT

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

Re: Store/insert API tokens for automatic refresh with Python

Greg_Deckler — Thu, 14 May 2020 21:40:23 GMT

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! 🙂

Re: Store/insert API tokens for automatic refresh with Python

benjikj_mcsp — Fri, 15 May 2020 08:33:24 GMT

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?

Re: Store/insert API tokens for automatic refresh with Python

Anonymous — Fri, 27 Aug 2021 13:49:18 GMT

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