Monitoring the automatic refresh with simple KPI's

[Urba34]

Hello folks

I'm struggling to produce a simple report based on powerbi.com automatic refresh. I want to know

1. When the refresh start
2. When the refresh is end
3. Refresh fail or not failed

Can anynone can give me some tips ?

I know something existing for Premium capacit but the point of this process it's to communicate something that evreyone can understand not a technical reports

Thanks for your help 😗

Regards,

[v-xuding-msft · Accepted solution]

Hi @Urba34 ,

You could check refresh date and refresh status: completed or failed in Refresh history.  If failed, you also could check the error message.

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#checking-refresh-status-and-hist...

[aj1973]

Hi @Urba34 

To refresh a report in the service you need:

* A Pro Power Bi License or a Premium Capacity

* You need to install a Power Bi Gateway on premises

* With a Pro license you have up to 8 automatic refeshes per day. 

* With Premium you have up to 48 refreshes per day

*  You can set up the time for each refresh

* The refresh ends when the dataset is updated

* A notfication email will be sent to a member when the refresh fails

Note: Premium Capacity is expensive and is more recommended for large entreprises(+500 Members)

[Urba34]

Hello,

Thanks @aj1973  for your quick reply. I have a pro licence my question is how to monitoring all my automatic refresh. How can i create a dedicate report for this ?

Regards

[aj1973]

Not with a Pro license. You need a work around to achieve that

https://community.powerbi.com/t5/Service/Monitoring-amount-of-data-that-is-refreshed/m-p/1129719

https://community.powerbi.com/t5/Service/Monitor-refresh-timing/m-p/320250

[Urba34]

Maybe i use the word by monitoring i mean manage the refresh fail or not

[aj1973]

Sorry but am confused now! 

If you want to receive notifications when the refresh has failed then you need to add your username or email address to the scheduled refresh menu.