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,
Hello,
thanks for your replies. The Data Source is a SQL Databse. Then I run 3 different python scripts and a lot of different Query Steps and Merges to get my result.
I have different SQL Procedures. They are like this: Insert column a to table a from column a from table b. (more difficult of course) and I need to know where column a is coming from. This was quite tough. It tooks me days to achieve this. I Dont think it s doable just with M Code.
So there is no other way then use a personal gateway?
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 🙂