Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@benjikj_mcspCan you share this python script, I am struggling with this problem at the moment.
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! 🙂
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
11 | |
5 | |
5 | |
3 |