Power BI/Python

More power in Power BI with Python — Part I

Prepare Power BI for the use of Python …

Image for post
Image for post

Installing Python

Image for post
Image for post
pip install pandas
pip install matplotlib

Prepare Power BI

Image for post
Image for post

Optional: create virtual environment

D:\>mkdir tmppy          //create a folder tmppy
D:\>cd tmppy
D:\tmppy>virtualenv venv //install a virtuel environment
D:\tmppy>.\env\Scripts\activate //activate it
(venv) D:\tmppy>pip install pandas
(venv) D:\tmppy>pip install matplotlib
(venv) D:\tmppy>deactivate //deactivate it
Image for post
Image for post
screenshot is German, but I think you got it ;-)

Testing the Python implementation in Power BI …

Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post

What to do next?

Tax consultant and IT-Nerd

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store