Can not get latest data from Azure sql database on power bi service

[Alice-Jen]

I have a report get data from Azure SQL database using DirectQuery.

Recently I found the report can not get the latest data from Azure sql database on power bi service . But it works well on the Power BI desktop version.
On the power BI desktop version

On the power BI Service

I don't know why it happened.  I worked well about one month ago.

Best Regards

[mohitkumawat · Accepted solution]

Hi @Alice-Jen ,

You can check and try a few things

• Data Caching: Power BI Service may cache DirectQuery data, so try manually refreshing or enable automatic page refresh.
• Gateway Configuration: Ensure the on-premises data gateway (if used) is online and correctly configured.
• Data Source Credentials: Verify that data source credentials in Power BI Service are correct and have the necessary permissions.
• Scheduled Refresh: Even for DirectQuery, scheduled refreshes may be needed for metadata updates; check if refresh is set up.

[Alice-Jen]

Thank you for your reply. I have tried enable automatic page refresh. It seems the data is refreshed normally now. I will check tomorrow also to see if the data is refreshed normally.