You may enable the option ‘Add Python 3.7 to PATH’ to add this into the environment or you may add it manually.
After successful installation of the setup, the following window will appear.
To successfully run Python in Power BI tool, you need to install two main Python packages using the command prompt:
We need to install the packages to use numerous prebuilt functions for data visualization and data manipulation operations. With the help of these packages, we can quickly get our desired output instead of writing long codes.
Pandas is an open-source, BSD-licensed Python library providing high-performance, and easy-to-use data structures and data analysis tools for the Python programming language.
1. Type the following command in command prompt.
Similarly, we need to install the Matplotlib plotting library for the Python programming language.
2. Type the following command in the command prompt.
In the Environment Variables, click ‘New’, and it opens a pop up box. Enter the below details in the edit user variable page.
Variable Name: PythonPath
Variable Value: C:\Users\rajen_000\AppData\Local\Programs\Python\Python37 (Change this Value according to your settings)
2. From the list, select Python Script and click on Connect.
When you click Connect, the below window pops up. A path of your local library will be mentioned (as highlighted), which will verify that connection is successful. If connection is unsuccessful, an error will be displayed.
Python is one of the most widely used programming language with a growing user base. Microsoft has integrated Python in Power BI and now python can be used for data analytics in Power BI. In this blog post, a step by step guide on downloading, installing and integrating python with Microsoft Power BI is presented.
More Checkouts for Power BI Training in Australia.
- Power BI Basic training course across Australia.
- Power BI Advanced training course across Australia.
- Power BI DAX training course across Australia.
- Power BI Corporate training across Australia.