Forum Discussion
Solved
Can not get latest data from Azure sql database on power bi service
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
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.
2 Replies
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.
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.
