topic Re: How can I automatically refresh data in a .pbix file saved on the server? in Report Server

How can I automatically refresh data in a .pbix file saved on the server?

MartaCz — Thu, 26 Oct 2023 10:43:22 GMT

Hi,

I built a PowerBI report that updates the data every month. The data is updated according to the schedule set in Manage/Schedules refresh. In browser it always shows current data. However, when I save the report file to disk locally and then open it in Power BI Desktop, I do not see the current data. The downloaded file contains only the data that was imported when it was saved to the Power BI Report Server.
I would like the downloaded file to contain current data.

In file I use Data Connectivity mode as Import, because some end users do not have access to the database.

Thanks in advance.

Re: How can I automatically refresh data in a .pbix file saved on the server?

d_gosbell — Fri, 27 Oct 2023 02:24:02 GMT

You cannot do this in Report Server, when you download a pbix it can only return the version of the file that was originally uploaded.

Re: How can I automatically refresh data in a .pbix file saved on the server?

MartaCz — Mon, 30 Oct 2023 09:28:56 GMT

Do you know any external tools that will help solve this problem?

Re: How can I automatically refresh data in a .pbix file saved on the server?

d_gosbell — Mon, 30 Oct 2023 23:46:21 GMT

No, I'm not aware of any tool or technique to achieve the outcome you are after