How can I create an auto updated business report in Azure?

Renee Jaworowski 1 Reputation point
2021-11-10T20:04:41.587+00:00

I am looking to take reports from different sources, to make up one business report that will update every hour or daily. One of my sources can send data through Azure Blob. Other information will be txt files.

Looking to import my sources into a database, then use Data Factories or a different report management tool.

Which Azure resources should I use, and how do I make them update together?

Thanks!

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 34,461 Reputation points MVP
    2021-11-10T23:23:41.96+00:00

    A possible solution is to use Azure Data Factory (ADF) to upload data to an Azure SQL Database (PaaS) as explained here and then use Power BI to connect to the Azure SQL Database, and read the consolidated data for creating a report/dashboard in Power BI.

    You can even create an Azure Logic App to trigger execution of an ADF pipeline if an event occurs like a new file arrives into Azure Storage Account or a new records is added to a table as explained on this video.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.