Python in Power Query and Power BI Service Refresh

[jonm818]

Hello, first time posting on here so please let me know if am missing anything 

Background:

I have a Power BI report and the sources (two excel files) saved in a single sharepoint folder. The Power BI Report is imported in Power BI Service as a dataset in a shared workspace. The workspace is shared with other members of my team who manage their own reports. 

The excel sources are system generated reports that are received via outlook and saved to the sharepoint folder, as mentioned above, on a daily basis using Power Automate. The two excel sources are imported and transformed using python (pandas libary) in Power Query to produce a single table, which is used for creating the visuals in my Power BI report. 

Problem:

The OneDrive refresh is set to ON for the dataset, but the report doesnt reflect the latest data.

I get the following error:

I have to manually open the Power BI desktop report saved in the sharepoint folder, hit refresh and then save. I then refresh the dataset in the workspace; I still get the error but atleast the data in the app is updated with the most recent information. 

Although the error doesnt explicitly state its a python error, i have BI reports which have an identical process without using python in power query, and they refresh daily without any issues. 

Can someone please advice if its possible to get this to refresh daily. I am doing something wrong? Or is there a better work around?

[lbendlin]

To refresh python scripts in the service you need to use a personal (not enterprise) gateway.