Scheduled Refresh Succeeds but Data Won't Update (Premium Capacity)

[Broderskap777]

Hello,

We're encountering an issue with our semantic model that's pulling data from Azure SQL. The data refresh has suddenly ceased to function properly. Neither manual nor scheduled refreshes are working as intended. Although the refresh should typically take about 10 minutes, it's only running for a minute, and while it reports success, the data itself remains stagnant.

I've come across a few similar threads discussing issues with other data sources, but unfortunately, none of the solutions provided seem to apply to our situation.

Attempts made to resolve the issue include:

• Deleting from test and redeploying from dev to test.
• Directly pushing from the desktop to test.
• Removing the parameter and refreshing.
• Deleting and then reinstating the parameter and redeploying from dev to test
• Trying OAuth2 and Service Principle authentication methods
• Uploading and refreshing from another workspace

None of Above has worked. We have no filters or parameters that should effect the imported data set. 

Interestingly, refreshing from the desktop seems to be functioning properly.

Any insights or suggestions would be greatly appreciated.

Thank you

[v-yifanw-msft]

Hi @Broderskap777 ,

Based on the information you have provided, the refresh report is successful but the data remains the same. You can follow the steps below to troubleshoot the error:

1. Check the refresh history, pay attention to any reported errors and check the error details.
2. If you are using a gateway, ensure that the gateway is up to date and configured correctly. Verifying the operational status and configuration of the gateway can help troubleshoot connectivity issues. For more information on gateway configuration, see the following link:
   On-premises data gateway - Power BI | Microsoft Learn
3. Consider the connection mode of the dataset. If in DirectQuery mode, the issue may be related to the way queries are executed against the Azure SQL database. If in Import mode, there may be issues with how the data is extracted or cached. See the following link to understand their limitations:
   Use DirectQuery in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Ada Wang

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