Monitoring solution: 2-wk implementation

The purpose of Kapacity BI Monitoring Solution is to provide insight into the usage of Power BI across a whole tenant, over longer time intervals than provided in standard solutions. The solution also provides insight into the ETL jobs in an Azure Data Warehouse orchestrated by Azure Data Factory (ADF). Finally the Monitoring solution also enables the users to get insights into the analytical models in Azure Analysis Services (AAS e.g. the tabular models), such as monitoring of response time and queries. The solution comprehends:

• Data is extracted using the Power BI Management API and a Log Analytics workspace
• API calls to the Power BI API are handled by ADF pipelines
• Data from Log Analytics are extracted using an Azure Function App. This contains two functions, one controller function to handle what data to get, and one worker function to retrieve data. The controller function passes messages to a storage message queue, which triggers the worker function once for each table to retrieve data from
• All data is sent to the Azure SQL Database, which then handles the transform and load into a data warehouse. There is an option to present the data in an Analysis Services tabular model
• Everything is orchestrated by Azure Data Factory.
• Optional Analysis Services to analyse data.

The solution features an out-of-the-box Power BI report, with a default design. The report is found in two different versions, one with an imported dataset, and one with a dataset based on an Azure Analysis Services-model.

The solution include following Azure services: Azure SQL Database, Azure Function,App Service plan (tied to Azure Function), Azure Storage, Azure Data Factory, Azure Key Vault, and Azure Analysis Services (optional).

The implementation is set to 2 weeks. The estimate may vary depending on Customer data/BI maturity and size of setup.

Example of scope of work:

• Setting up monitoring
• Import files (Log analytics config)
• setup deployment pipelines¨
• etc