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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

dierci
Regular Visitor

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors