From the course: Power BI Data Methods (2019)
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Running Python scripts
- In Power BI, we connect to a Python script by first selecting Get Data at the top. We can select More at the bottom which will bring up a new screen. Now type in Python in the search bar, and select Python script. We see at the bottom, this is where Python is installed. However, if you need to change the settings on your computer to get Python to run, let's click out of this menu, and point to a different folder. On File, select Options and Settings, Options. Choose the Python scripting tab. Click the drop-down menu, and select Other, where you can point your Python home directory somewhere else. I'm going to cancel that because mine is already fine. I'm going to select to get data again. Again search for the Python script. Select the Python script again. Here I paste in a Python script that uses Panda and NumPy to produce a data frame output. It doesn't do much, as you will see, but it shows how a Python script…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.