Pull Data from Dataflow using Python

[omkarj]

I am trying to pull data from Dataflow and transform that data using Python. But I dont see any API or way to connect to Power BI Dataflow using python. Can anyone please help if anyone know how to connect to POwer BI Dataflow using Python Script and the way (API, OAuth) etc would help to connect to Dataflow and fetch Data from Dataflow using Python ??

[lbendlin]

Only Datasets are exposed via the XMLA endpoint connectors.  Dataflows cannot be accessed directly.  Not sure if it is a good idea to ever try this but feel free to raise it as an idea.

Always keep in mind that Power BI is a downstream application.  What you really want to do is point your python to the actual source of the data, further upstream.

[omkarj]

Can you help me with how we can use XMLA endpoints ? or any link where I can find info about this ?

[lbendlin · Accepted solution]

Dataset connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Docs