Scheduled Refresh for Python Scripts in Power BI Service: Seeking Guidance for Cloud-Only Setup

Hi SU  Well, it doesn’t support cloud-only scheduled refresh for Python scripts in Power BI Service. To achieve this, deploy the script to a cloud platform like Azure Functions or Azure Automation, and write the output to a supported source like Azure SQL or Blob Storage. Alternatively, replicate the script’s logic in Power Query or use a cloud ETL tool like Azure Data Factory. Connect Power BI to the cloud data for seamless scheduled refresh.

Hi SU,

Thank you for reaching out to the Microsoft Fabric Forum Community.

The solution provided by Akash_Varuna is correct. You can use azure services to run the python script in the cloud. For azure services paid service is not required as you login to azure free account you get a credit of $200 and first 30 days trail period after completion of this period need to switch to paid version 
Or, as stated in the Microsoft document, you can use the on-premises gateway for schedule refresh.  

Below is the Microsoft document for more details: 

Use Python in Power BI Power Query Editor - Power BI | Microsoft Learn 

Install an on-premises data gateway | Microsoft Learn

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.