Search code examples
pythonparameterspowerbipowerbi-desktop

Power BI Pass Parameter Value to python Script Variable in get Data


I have a Power BI report that uses Python Script to get data.Is it possible to pass the parameter value give my the user as a variable in this python script?

In the below example I want the user to pass their user name and password as parameter into this script.

Sample Code

import requests
import pandas as pd

user = "UserName"

Pass = "Password"

.... ...

Kindly advise. Thank You


Solution

  • I had the same issue. It's possible to pass a parameter to the Python script.

    username = """ & UsernameParameter & """
    password = """ & PasswordParameter & """
    

    I hope it helps you!