Unable to Refresh Data in PowerBI Web that uses Python Scripts

[HEADS]

We have several data sources that pull data out of Salesforce and then process the data using python scripts. The only issue is that we can not refresh the data in web or use Scheduled Data Refreshes because Python doesn't exist in app.powerbi.com.

We can pull down the dashboards and then refresh using PowerBI Desktop but we'd like to be able to have automated refreshes.

Is it possible to have Python installed into our server/capacity so we can take advantage of these features and still use Python. We have a fabric capacity assigned to our workspace. I'm not sure if its a server instance dedicated to our workspace that we can update and install files into. Perhaps I could remote in somehow and install python and solve this issue for us.

Thanks in advance!

[v-priyankata]

Hi @HEADS 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[arvindsingh802]

You need a Personal Gateway installed on the machine where the file is located, and where Python is installed.
Then enable scheduled refresh for the dataset – Need to enable scheduled refresh for the dataset with Python scripts

[HEADS]

Hi @arvindsingh802 ,

Hi,

Thanks for your reply!

It isn't an option for me to have a Personal Gateway on my physical device that would stay connected to dashboards/semantic models that live in app.powerbi.com. Is there any solution that microsoft offers that can live purely on app.powerbi.com?

[arvindsingh802 · Accepted solution]

Unfortunately that's only option
You should host personal gateway on a server so that it would be available during scheduled data refresh.