Scheduled update successful but data not updating for next day

[steno]

Hello,

I’m working with two Power BI reports that use the same DataBricks datasource, connected via a Personal Access Token (from a different tenant). I took the first report, made some minor adjustments (theme and a few visuals), and uploaded it as a second report to a Power BI Premium Workspace. We need both versions live for comparison, as we’re deciding which one to keep.

The problem is that the second report isn’t updating the data properly. Although the refresh works multiple times during the day, when I check the report next day by downloading it and opening it in Power BI Desktop, the latest data timestamp is always around 17:55. Despite the scheduled refresh showing as successful, the data doesn’t seem to update after this time, and the next day it won’t refresh automatically. Manual refresh in the Power BI service updates the data correctly.

Here’s what I’ve tried and observed:

• The refresh schedule runs multiple times a day (I’ve adjusted the schedule to troubleshoot), but the issue persists.
• If I manually refresh the report in the Power BI service, the data updates correctly.
• I renamed the second report, uploaded it again as a third version, and this one updates without any issues.
• The first report (the original) has no problems and updates as expected.
• I can’t delete the second report immediately since its embed link (via iframe) is already in use, and switching the link would take some time.

Details:

• Power BI Version: Desktop 2.137.751.0 64-bit
• Data Source: DataBricks (connected via Personal Access Token, from a different tenant)
• Workspace: Power BI Premium Workspace
• No errors or warnings during the scheduled refresh
• Scheduled refresh times: Multiple times a day, latest timestamp in Desktop is around 17:55
• Same queries and connection settings for both reports
• Embed method: iframe
• Manually refreshing in the service works fine
• Connection to DataBricks is fine on all reports

Does anyone have insights into why the second report would fail to update the data, even though the refresh status shows as successful?

Thanks in advance for your help!

[Anonymous]

Hi, @steno 

Clear the cache and try, or consider recreating the second report to make sure all the settings and configurations are the same as before, and then try to see if you can schedule a refresh, maybe the update data is lagging behind.

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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

[rajendraongole1 · Accepted solution]

Hi @steno - Check both Power BI and DataBricks logs around 17:55 to see if any errors or disconnections occur during that time.Retry with a Different Token: Try generating a fresh Personal Access Token for the second report and see if the problem persists.Refresh Scheduling Adjustment: Modify the refresh schedule of the second report to ensure it doesn’t overlap with any other data refreshes.

In Power BI, ensure that direct query mode (if applicable) is properly configured and that the gateway (if used) doesn't have caching enabled. Additionally, check for any delays in the gateway that might prevent a full refresh.

Also, verify whether any background dataflow refresh limits are causing a throttle or lag in the data refresh.

If these steps don't resolve the issue, contacting Power BI support or reviewing detailed refresh logs might help uncover deeper issues related to the Premium workspace or the DataBricks connection.

similar solved links:

Solved: Inability to refresh PBI report( in Power BI Servi... - Databricks Community - 9365

Re: PowerBI Service Data Refresh Issue - Azure Dat... - Microsoft Fabric Community