Power BI For Data Science

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

Python integration into Power BI desktop

  • 1.  Python integration into Power BI desktop

    Top Contributor
    Posted Aug 11, 2018 02:53 PM

    We are excited to announce that Python, a programming language widely used by statisticians, data scientists, and data analysts, is now integrated into Power BI Desktop. Once you enable the feature in the preview settings, you can use Python to do data cleansing, analysis, and visualization.

    The first integration experience we added is the ability to run Python scripts directly in Power BI Desktop to create your data model. You'll see an option for this new connector in the Get data dialog.

    Also from the desktop

    After selecting this option, you'll be able to paste in your script.


    The Python integration in the Query Editor lets you perform data cleansing using Python and perform advanced data shaping and analytics in your data, including completion of missing data, predictions, and clustering, just to name a few.

    Lastly, you can use Python to create new visuals on your report. Just like R visuals, the Python visuals will update with data refreshes and cross-filtering. However, the visual itself is not interactive.


    Pablo Moreno
    Data Intelligence Engineer
    Dell Technologies