How to run python code in power BI

To run Python code in Power BI, you can use the "Python script" option in Power BI Desktop. Here's a basic guide:

1. Open Power BI Desktop and load your data.
2. In the "Home" tab, click on "Transform data" to open Power Query Editor.
3. Select the table or query where you want to run Python code.
4. Click on "Transform" and then choose "Run Python script."
5. Enter your Python code in the editor that appears.

Make sure you have the required Python environment set up on your machine, and Power BI supports integration with it. You can configure your Python environment in Power BI by going to "File" -> "Options and settings" -> "Options" -> "Python script."

After running the Python script, the output will be added as a new column or table in your Power BI dataset. Note that you need to have the Python script installed on your machine and correctly configured in Power BI for this to work.

Comments

Popular posts from this blog

I am from mechanical background.. how I can start with python? Tell me career opportunities also .

Root Finding in Python: Solving and Visualizing Equations with SciPy

Here's a step-by-step guide to help you install Visual Studio Code (VSCode) for Python on Windows