Live data not updated when refreshed.

[Mikekeji1978]

After importing the data from the website VIA API and creating a hydrograph dashboard. The imported data is not updated daily after clicking the refresh button. Not sure if I have to publish the Power BI dashboard before it starts updating the live data, or it can be updated within the Power BI. Not sure what I've done wrong. It is just a simple flow time series dashboard. do I need any further functions or queries to add for the daily update to work? Many thanks

[Akash_Varuna · Accepted solution]

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.

[Mikekeji1978]

Okay. Well noted. This is very helpful. Thank you very much.

[v-veshwara-msft · Accepted solution]

HI @Mikekeji1978 ,

Thanks for reaching out to the Microsoft Fabric Community.

Based on your description, here are two possible scenarios:

1. 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.

2. 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.

[Mikekeji1978]

Well noted. This is very helpful. Thanks so much

[Akash_Varuna · Accepted solution]

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.

[Mikekeji1978]

Okay. Well noted. This is very useful. Thank you so much