Forum Discussion
Refresh in Service is no Working - Python Query Editor
Hi. Please help us understand the datasource. Are you running python as the first step for getting data? I mean using the get data from python script. Or are you getting data from a source and then runing a py script as a transformation? if it's this second option please share with us which the datasource is, beacase the source could be related to the issue instead of python.
You can also share the python transformation, maybe it's not necessary to use it and we can find an alternative of the transformation with Power Query.
Please check out what Ibendlin is saying. Running Python at that level must configure an On Premise Data Gateway in personal mode to run a refresh at Power Bi Service.
I hope that helps,
Super UserYou should first attempt to do this in SQL. Then in M (everything can be done in M) . Running Python scripts in Power Query should be your very last option. And yes, it absolutely requires a personal gateway if you want to refresh in the service.
Yeah you re probably right. Thanks for your reply 🙂