Trigger Python script in PowerBI workflow

[Ruedi007]

Hello!

I have a python script that I cannot run in the PowerBI Python Scription option since it is to complex. The script calculates some statistics based on data within my Azure DB and puts the data into a table called "Statistics".

I have a PowerBI Report and Dashboard that is based on this Statistics Table. And that has to be refreshed as soon as data in a given table of the Azure DB changes.

I figured out that I can use Microsoft Flow (https://www.youtube.com/results?search_query=microsoft+flow+powerbi Minute: 8:41) to trigger a refresh of the Dashboard but I am not sure how to trigger the python script within this workflow.

If there is anyone who can help me out that would be great.

Thanks in advance!

[Anonymous]

What was your solution? 

[v-xicai]

Hi @Ruedi007 ,

You may refer to the links:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts,

https://community.powerbi.com/t5/Desktop/how-to-get-amp-process-data-from-amp-using-python-scripts/t...,

https://www.sqlshack.com/power-bi-desktop-and-python-like-peanut-butter-and-chocolate/ .

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.