Complete automated Python script

[sp_mike]

I have a Python script which gets data from a website. The data is available in Power BI, I can "load" it.

However I want to take this script a step further. I want to load (and convert datatypes) also using my script.

My ultimate goal is to have my script executed when I start Power Bi and everything is handled using the script? Even better, using some kind of timer, so it is executed (in Azure) when I am asleep 😉

Would that be possible?

[Anonymous]

Hi @sp_mike ,

Have you tried Python script connector.

Best Regards,

Jay

[sp_mike]

Yes, but I want to have the script executed while I am asleep

[amitchandak]

@sp_mike , Have you already configured python script as a table and is it not working?

example

PowerBI Abstract Thesis: How to make Python work with Power BI: https://youtu.be/5D0BkNsu5CM

[sp_mike]

Sorry, the video did not help. I already have the data but I want to automate the load/transform.