Power BI Service notification with Azure Storage Table

[NielsvhPVH]

We want to use "Power BI Service" (online) for  fleet management purposes. So location, running hours, fuel usage etc. per asset (vehicle / machine). Data will be stored in a Azure table storage. Every row will be an asset and data of these assets will change several times a day. The first step that we want to accomplish is to generate a notification. For example if one of the assets or a group of assets will have a change of location or when a battery voltage will drop below a certain voltage. Then we want to generate an email with this notification and sent it to people inside and outside of our organisation.    

Questions:

1. Will "Power BI Service" the proper tool to generate notification based on a Azure storage table? If yes how can we do that. If not what other tool can fulfil our needs?
2. When will  "Power BI Service" update the data from the Azure Storage table? And can this be adjusted.

[v-shex-msft]

HI @NielsvhPVH ,

#1, No, power bi not contains feature to check datasource status and send notifications. You can try to use microsoft flow to setting triggers based on conditions.

#2, Azure storage table is a cloudy datasource with connect direct mode, you need to configure your data credentials to enable data refresh.

Data refresh in Power BI

Regards,
Xiaoxin Sheng