Is it possible to connect PowerBI data to python?

[ay-chang]

Hi I was just curious if I would be able to load data out of PowerBI into python without needing to export a CSV. I know you can load data into PowerBI with python but I wanted to know if you could do the reverse. For example, if I have a report where I've added multiple elements and columns to the data set, I would like to connect what I have in PowerBi to a python script. Any help appreciated!

[prs08087g]

1

Yes, you can call libraries that you have installed on your local machine (provided you import them) or if you're talking about the Power BI service (online), you can use any of the many libraries they support.

[ppm1 · Accepted solution]

You can connect to Analysis Services (behind the scenes in Power BI) with Python.

Using Python to Execute DAX Queries in Power BI & SSAS Tabular - Part 1 (antmanbi.com)

Pat