Forum Discussion

preetisb15's avatar
preetisb15
Frequent Visitor
6 years ago

Python datasource refresh via service

Some context:   I have written a python script to extract directly from a cloud app and do some cleaning & transformation (within PowerBI desktop)  Then I have built some tables / visulation...
Need Help
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi preetisb15 ,

 

You may implement schedule refresh via Personal Gateway for Python in Power BI Service. The additional steps are the following:

 

  • Install the Personal Gateway - you need a Personal Gateway installed on the machine where the file is located, and where Python is installed, see more:install and configure gateway.

 

  • Enable scheduled refresh for the dataset – Need to enable scheduled refresh for the dataset with Python scripts, see :configure the schedule refresh.

 

You may resolve the issue via the troubleshooting link :https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios .

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • preetisb15's avatar
    preetisb15
    Frequent Visitor
    6 years ago

    Hi v-xicai ,

     

    Thanks this works! however, the scheduled refresh only works when my computer is on (i.e when the gateway is running in my computer). When my computer is shutdown - i get refresh errors.. is that expected with personal Gateway?

    • v-xicai's avatar
      v-xicai
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi preetisb15 ,

       

      For both enterprise gateway and personal gateway, because the gateway runs on the computer that you install it on, be sure to install it on a computer that's always turned on. For better performance and reliability, we recommend that the computer is on a wired network rather than a wireless one. If a gateway uses a wireless network, its performance might suffer.

       

      You shouldn't install a gateway on a computer, like a laptop, that might be turned off, asleep, or disconnected from the internet. The gateway can't run under any of those circumstances.

       

      Best Regards,

      Amy 

       

      Community Support Team _ Amy

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.