How do I use Python scripts in Power BI

Question

I have installed Anaconda and the latest version of Python on my local computer but still I am not able to integrate it with Power BI. There are the challenges I am facing:

1. There is no option for me to run scripts

2. No option available for the visualization

I have no idea how to enable them in my Power BI Desktop

Answer 1

Hi,

You can create interactive reports out of your data using Python scripts in Power BI.

In order to do so you need to enable python scripts option in Power BI so that it appears in the visualization pane.

Following are the steps in order to enable python scripts

Step 1: Select Options and Settings from the file Menu

Step 2: Select Options and then check python support in preview features

Step 3: Enable python scripts

Step 4: Choose Python option from the visualization pane and write your Python scripts in the script editor

Now you can finally load you your data to power bi desktop and add fields to the python visualization using an external IDE or you can run your own python scripts as well.

Hope this helps!!