As the title states I'm looking for some help with running my python script in Power BI.
I currently have the following setup that I need to automate:
- My data is on an Azure DWH. I export the dataset to a CSV file.
- This CSV is loaded in Python and I'm basically transforming/enhancing the dataset here. (I'm applying text analytics from the Cognitive Services and K-means clustering). Then I export the dataset to CSV.
- Now I load the CSV in Power BI to do the visualisation.
Unfortunately we're not allowed to run Python scripts on the Azure DWH as this is resource intensive.
My plan is to connect directly to the DWH from Power BI to load in the data. Now I want to schedule the python script to run lets say every week or something. However, I don't know if this is possible. Has anyone got experience with this?
I'm currently doing some research on "Python script editor" and "Python script". Is it possible to write back data into the Azure DWH using the python script editor?
Looking forward to your reply and thanks in advance.