CODEWITHSUNDEEP
pythonpowerbienvironment-variables
Sloth87
Sloth87

Reputation: 785

Using environment variables with Python in Powerbi

I have a script that connects to a third party API that uses a public and secret key. The connection is written in python and works on PowerBI desktop and also on the web app in production.

However the keys are hard coded into the script and this doesn't feel like best practice. Is there a way to use Environment Variables in PowerBI so I can remove the keys from the script?

Upvotes: 2

Views: 1203

Answers (1)

skittely
skittely

Reputation: 21

I was just working on this today! I was able to store my credentials as environment variables on my computer and then call them in my python script using os.getenv("SECRET_KEY") etc.

I did have to restart my PowerBI Desktop after saving them to my computer.

Additional information - os is a python library to interface with your local machine. os.getenv accesses the environment variables that you have stored on your system. Windows users can create env vars here and mac users typically set them via terminal like this

Upvotes: 2

Related Questions