Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Nurry90
Helper I
Helper I

Reports not updating after scheduled refresh

Hi All,

 

I am having an issue with my reports on the PowerBI service. I have published a report and have set up my gateway and scheduled a refresh of the data from my SQL server. The problem is, that after the scheduled refresh (and even manual refresh), which doesn't fail, my report is not updating. I have read some posts saying that there is a delay for report refresh, but mine have never updated.

 

Is there something I have done incorrectly from the start I wonder? Does anyone have any suggestions as to what this may be?

10 REPLIES 10
Anonymous
Not applicable

Hi there! I am wondering if you figured out the problem? 
Can you please share your answer if you did?

Anonymous
Not applicable

i think i found my problem. its due to the setting in my query 2023-07-31 10_25_25-10.65.3.61 - Remote Desktop Connection.png

Anonymous
Not applicable

Hello @Nurry90 , 

 

I have been having the same issue for months, have you found a solution by any chance?

I'd be so grateful if you could share it because I am having a hard time regarding to getting help on this subject.

Hi, I faced a similar issue a few months back. Are you by any chance renaming the report after its's published in the Service? Regards, Veena Shenolikar
v-rzhou-msft
Community Support
Community Support

Hi @Nurry90 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

 

Best Regards,

Rico Zhou

v-rzhou-msft
Community Support
Community Support

Hi @Nurry90 

Could you tell me what kind of connection mode you use to get data from SQL Server(Direct Query or Import)?

Firstly please check whether your gateway works normally. Can you succeed to refresh other reports?

If it works well, please check your refresh history in Setting - Datasets. If it shows failure, please show me your screenshot of its details.

And check your Date Source credentials. If it shows error, please edit your credential again.

1.png

Here are some blogs about refresh, I hope they could help you.

Blog: Troubleshooting refresh scenarios

Blog: Configure scheduled refresh

Blog: Data refresh in Power BI

 

Best Regards,

Rico Zhou

 

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

mahimabedi
Responsive Resident
Responsive Resident

Are you you seeing updates when you refresh locally? Wondering if its a refresh issue, or a data model issue.

 

Also to confirm that its not a cache issue, i suggest clicking on the refresh icon on the report page, which refreshes just the the visual layer.

 

PS: Please mark this post as a "solution"  if this helps solving the issue and/or hit the "thumbs-up" button if you found this insighful. Thanks.

Hi  @mahimabedi,

 

I have refreshed on the report visual, and still no current tata coming through.

 

Also, report is showing as refreshed in the workspace too. See below. What data model issues could it be?

 

Nurry90_0-1603945744570.png

 

Maybe there is a step in data transformation thats filtering out the data. If you are seeing the expected behaviour in desktop and not in service, that points to a issue in the service. IF however it doesnot work in desktop either, it might make sence to debug within the dekstop file.

 

PS: Please mark this post as a "solution"  if this helps solving the issue and/or hit the "thumbs-up" button if you found this insighful. Thanks.

Hi @mahimabedi ,

 

My refreshes are working fine on Desktop, it's only when on the service that they are not updating with the scheduled refresh. I don't know how to fix this?!

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.