Need some idea to write integration

Hi Alpesh1986 ,

To achieve your task, you can consider using Azure Functions and Azure Logic Apps.

Here's an approach you can consider:

1. Create an Azure Function that fetches data from the APIs every hour using a timer trigger. You can use the checkpoint logic to ensure that only new data is fetched.

2. In the Azure Function, you can use the Azure Key Vault to securely store any secrets that are needed to access the APIs.

3. Once the data is fetched, you can store it in Azure Blob Storage or Azure SQL Database.

4. Create an Azure Logic App that is triggered when new data is added to the storage account or database.

5. In the Logic App, you can use the Power BI connector to ingest the data into Power BI. 6. You can then create a Power BI dashboard to display the data.

This approach ensures that your data is securely stored and accessed, and that it is ingested into Power BI in a timely and efficient manner.

Refer to:

Overview - Azure Logic Apps | Microsoft Learn

Azure Functions Overview | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.