topic Report shows old data, even after successful scheduled refresh in Report Server

Report shows old data, even after successful scheduled refresh

Anonymous — Fri, 04 Oct 2019 08:53:28 GMT

Hi all,

My report in the Power BI Service shows old data (as it was at the moment I published it), even after the scheduled refresh was completed successfully. No error messages whatsoever. If I 'just' do a refresh In Power BI Desktop it shows me the correct data. Therefore I assume the report in the Power BI Service should show the same data as the report on Power BI Desktop.

Any ideas?

Thanks!

Re: Report shows old data, even after successful scheduled refresh

1123 — Wed, 05 May 2021 07:38:04 GMT

Hi,

I have the same problem. Is there anyone who can help?

Anonymous could you solve it?

Re: Report shows old data, even after successful scheduled refresh

DavidAnton — Mon, 21 Jun 2021 10:48:12 GMT

I had the same issue. Here is what caused the issue in my case.

There are two options for each table in the Power Query tab that you can access by Right Clicking the table and selecting Properties:

Enable Load
Include in Report Refresh

Make sure the second one is ticked. 🙂

Re: Report shows old data, even after successful scheduled refresh

NMP02 — Tue, 06 Dec 2022 05:38:36 GMT

Hi guys,
Experiencing the same issue, the 39 "Too much invoice number" it should be "Blank".
I encountered this issue last week and power bi fixed it on its own.

Maybe I can conclude that it is in the system of the power bi is the cause right??

Re: Report shows old data, even after successful scheduled refresh

d_gosbell — Wed, 07 Dec 2022 02:42:21 GMT

NMP02 you should probably double check the Report Server log file to make sure there were no unexpected errors. I'd start by checking the RSPowerBI* log files and maybe the ReportingServicesService* files. If the status of the refresh shows complete and there are no errors in the log and you are using the same credentials to connect to the same data source then you should see the same data. If you don't you might need to raise a support ticket.

Re: Report shows old data, even after successful scheduled refresh

Arielcchy — Wed, 19 Apr 2023 17:13:00 GMT

I encountered the same issue. (All execution were done in Power BI service)
Visuals catched the data before auto-refreshed. In other words, my fact table matched the index from the old dim table, which does not exist in the current datasets anymore since auto-refreshed was completed and successful, therefore all data related to that dim table was mismatched.

Temperary fix is manual refresh the datasets and manual refresh report visuals.

However, is there any permanent fix for this issue?