Forum Discussion
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.
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 Akash,
Thank you for your response.
Could you please guide me on whether a paid Azure service is required for this? Your clarification would be greatly appreciated.
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.
Hi SU,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
