topic Automate/ Real-time the Dashboard in Qlik Automate

Automate/ Real-time the Dashboard

Olivia_Rose — Tue, 25 Feb 2025 04:29:40 GMT

Hi Experts,

I have created a dashboard which extracts data from an excel file. Now I want to automate that by extracting that data from Azure DB(Original data source) to my dashboard.

1. What is the correct way to do that?

2. Creating an API how can I do it?

3. How do I reload/ refresh that data again and again?

Note: The original data source is Azure DB. Usually I download that excel data from an interface which by selecting the specific date range. Then downloads the .csv file and update the data to the data location which use as path for the created dashboard. But now I want to automate this process.

I would be much obliged if you can help me.😊 Any new ideas or suggestions are welcome.!

Re: Automate/ Real-time the Dashboard

JandreKillianRIC — Tue, 25 Feb 2025 07:38:22 GMT

Hi @Olivia_Rose

You will need to create a connection to the AzureDB.

Then you can set a reload schedule on the application - Click the 3 dots "on the application" > Reload Schedule

This will give you 1 hour reloads, If you need a faster reload time like every 30 minutes you can check this link to change the reload schedule using the Qlik API.
https://qlik.dev/apis/rest/reload-tasks/

Why do you need to create a API? (Your point 2 on the question)

Regards Jandre

Re: Automate/ Real-time the Dashboard

Olivia_Rose — Fri, 21 Mar 2025 06:12:38 GMT

@JandreKillianRIC

Thank You.!☺️