Forum Discussion
Live data not updated when refreshed.
- 1 year ago
Hi Mikekeji1978 It might be related to the configuration of your data source or refresh settings. Ensure that the API data source is set up correctly with authentication and supports live updates. If you're using Power BI Desktop, refreshing only updates the data locally. To enable automatic daily updates, you need to publish the dashboard to Power BI Service and set up a scheduled refresh under the dataset settings.
- 1 year ago
HI Mikekeji1978 ,
Thanks for reaching out to the Microsoft Fabric Community.
Based on your description, here are two possible scenarios:
-
If you are clicking Refresh in Power BI Desktop but the data does not update, check your query. If it uses fixed values, such as a hard-coded date, the data will stay the same after each refresh. Consider using dynamic functions like DateTime.LocalNow() to get the latest data.
-Go to File > Options and Settings > Data Source Settings, clear permissions for the API source, and reconnect using the correct credentials.
-Enable Tracing in Power BI Desktop for detailed logs. Go to File > Options and Settings > Options > Diagnostics, and enable Tracing. After refreshing, check the logs in the Power BI Desktop\Traces folder for any errors or connection issues.
-If the dataset is large or the API query is complex, refresh might take longer.
-Ensure you are using the latest 64-bit version of Power BI Desktop. The 32-bit version may not handle large datasets or complex queries well.
-
If you expected the Refresh button in Power BI Desktop to trigger a daily update automatically, note that it only updates the data when you click it. To enable daily refresh, publish the report to Power BI Service and configure scheduled refresh under Semantic Model Settings > Refresh.
Let us know if you need any further assistance.
Also thanks to Akash_Varuna for prompt response.
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to give a kudos and Accept as the solution to help the other members find it more quickly.
Thank you. -
Okay. Well noted. This is very helpful. Thank you very much.