Forum Discussion
Python Script Automatic Refresh
Does Power BI Web Service support automatic refresh with Python Scripts? It doesn't even give me an option to set up a Gateway.
Below is the email I keep getting when I set up automatic refresh.
Thank you!
8 Replies
HI eliele ,
What code you test? Can you please explain more about this?
In addition, power bi has limitation on run python script, please take a look at following link to know about this:Run Python scripts in Power BI Desktop
Current it only support import mode to get data, live mode seem not works. (you can install a personal gateway to handle refresh)
Regards,Xiaoxin Sheng
Hey Anonymous ,
All I do is data manipulation in Python. I import data from a database that with no problem automatically updates, and then do some data manipulation using python. I do not use python to import data - only to manipulate the current data.
In terms of Gateway, it doesn't even give me an option to setup one like with R. If I manipulate data with R, the Dashboard gets automatically updated using the Gateway; if I use python, it doesn't.
Below are the modules I use:
import datetime
from datetime import timezone
import time
import dateutil
import calendar
import pandas as pdThank you!
HI eliele ,
As I said, current it only support to use personal gateway to handle python scripting data source refresh, you can take a look at following blog to know more about this:
Python visualizations in Power BI Service
Python support in Power BI personal gateway
Python can be used for data preparation or for analytics in your Power BI reports, either with a Python script data connector or by using a Python script in the Power Query editor for data transformation.
When you publish a Power BI report with Python scripts to the service, these scripts will also be executed when your data is refreshed through the on-premises data gateway in personal mode (personal gateway).
To enable this, you must ensure that the Python runtime with the dependent Python packages are also installed on the machine hosting your personal gateway. Note, Python script execution is not supported for on-premises data gateways shared by multiple users.
Regards,
Xiaoxin Sheng
