Forum Discussion
Need some idea to write integration
Hello Team,
I am my custom apis, I want to write integration to fetch data continues based on checkpoint logic every 1 hours (I have 4 apis which need to call in sequence to fetch all data). and need to ingest data in to power BI to show data on dashboard.
Can you please suggest the best approach to achieve my task with a secure way.
I have seen there is a Power BI Rest API endpoint and customer connector. Can you please suggest best way to achieve my goal or provide solution to my organization
2 Replies
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.
v-jianboli-msft Thanks for the solution. Overall, looks good to me.
However, As per my research. I want to use Power BI rest endpoints as I want to run on my server. Is there any commendation, how I can achieve using that? that will be great help
