Python Datasource not refreshing

[Bokangmaela]

Hi,

I have setup a python script as my datasource and I was able to schedule refresh a few months ago and the data was refresh recently when I checked the data the refresh feature doesn't work. I get the following error message

You can't schedule refresh for this semantic model because the following data sources currently don't support refresh:

• Data source for Query1

Does any know of any changes that has been made that affects the refresh schudeling on python datasources?

[v-nuoc-msft]

Hi @Bokangmaela 

You can't refresh on Power BI using Python scripts because Power BI doesn't support this feature.

You can try the following methods to solve this problem:

To enable scheduled refresh of your Python dataset, you need to enable Scheduled refresh and have a Personal Gateway installed on the computer that houses the workbook and the Python installation. 

You'll need to have the pandas library installed in your Python environment for the previous script code to work properly.

For the Python scripts to work properly in the Power BI service,all data sources need to be set to public.

You can view the link below for more details:

Solved: PowerBI Service with Python as Data source - Microsoft Fabric Community

Regards,

Nono Chen

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

[Bokangmaela]

Hi @v-nuoc-msft,

Thanks for your response.

I have install all the requires packages that are needed to run the python script. The script is running on Power BI Desktop however when the report is published to Power BI serivce the python dataset isn't able to be refreshed. For a strange reason it was able to last month but this month it's unable to. I am not sure what changed since then on Power BI service but I hope there is a work around to this. 

Kind Regards,

Bokang Maela