Skip to content

Latest commit

 

History

History
48 lines (37 loc) · 2 KB

README.md

File metadata and controls

48 lines (37 loc) · 2 KB

Refresh Power BI dataset

Summary

This sample shows how to refresh a Power BI with an Azure Logic App triggered by a metric alert from Azure Application Insights as logged by carbon-appinsights. The metric alert is triggered when carbon emissions in the region of the Power BI dataset are below a certain threshold.

Power BI Dataset refresh Logic App

Usage

This sample, like all others, requires the carbon-appinsights solution deployed for at least 1 monitored region.

To use this sample you will need the Group ID and Dataset ID of a dataset to refresh in Power BI. You can get these from the Power BI portal by selecting app and then select the dataset properties from the menu. The Group ID and Dataset ID will be in the resulting URL.

Fill in the parameters in the main.parameters.json file to your situation. The following table displays their purpose.

Parameter Purpose
location Location / Azure region for the deployment
environment Lifecycle environment used in name convention, eg: dev or prd
alertRuleScope Resource ID of the Application Insights instance with the carbon-appinsights metrics.
alertRuleRegion Azure region monitored by the carbon-appinsights metric.
lowEmissionTriggerThreshold Threshold below which the alert is triggered in gr/KWh.
projectName Name used in name convention for resourcegroup
pbiUsername User Principal Name of the user to connect to the Power BI dataset
pbiGroupId Group ID of the Power BI dataset to refresh
pbiDataSetId Dataset ID of the Power BI dataset to refresh

You can then run the deployment with azure-cli from the command line:

az deployment sub create -f main.bicep \
    --parameters @main.parameters.json \
    --location westeurope

After running the deployment you will need to manually authenticate the created powerbi Api connection resource in the Azure portal.