topic Re: Scheduling data refresh for python script data source in Report Server

Scheduling data refresh for python script data source

Anonymous — Wed, 24 Mar 2021 23:16:04 GMT

Hello Guyz,

I created this report with a python script which extracts data from a mongodb using an aggregation query, I have successfully pulished the report to the PowerBI premise server which is what we cureently have.

But I noticed the report is not refreshing when I view it, as the last refresh datetime is not changing. I read from some articles out there that data refresh only happens when you view the report, which I did and but last refesh time is not changing.

I will greatly appreciate your contribution on how to get this report to refresh.

Thank you.

Re: Scheduling data refresh for python script data source

lbendlin — Mon, 29 Mar 2021 00:15:05 GMT

did you create a personal gateway, and did you set up a refresh schedule?

Re: Scheduling data refresh for python script data source

Icey — Wed, 31 Mar 2021 09:45:21 GMT

Hi Anonymous ,

I have successfully pulished the report to the PowerBI premise server which is what we cureently have.

Do you mean "Power BI Report Server"? But to my knowledge, Power BI reports with Python scripts or visuals can't be saved to Power BI Report Server currently.

Reference:

Comparing Power BI Report Server and the Power BI service - Power BI | Microsoft Docs

So, in fact, you publish the report to Power BI Service, right?

If so, please check if you have installed Personal Gateway and configured scheduled refresh correctly.

Reference:

Python visualizations in Power BI Service | Microsoft Power BI Blog | Microsoft Power BI

Configure scheduled refresh - Power BI | Microsoft Docs

Best Regards,

Icey

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

Re: Scheduling data refresh for python script data source

Anonymous — Fri, 02 Apr 2021 20:13:33 GMT

The report was save to Power BI Report Server, I just read from the comparism between Power BI Service and Power BI Report Server, save and refesh functionality is only achiveable by Power BI Service.

I'II route the process through a network drive

Thanks guyz.