Refresh Diagnostic Log

[ElliotP]

Afternoon,

Recently I've been workign to make sure my pbix's when published to powerbi web are able to refresh within the 2hr? time limit. I've cleaned up my pbix's as much as possible and they are refreshing now, but still take an hour or so. I was wondering if there is a way to download a log about which parts of the refresh are taking the longest, etc?

I've noticed the DTU's on my azure sql server caps out at 100% for the entire period when the refresh is occuring, so I'm curious how much the report would use DTU wise so if I should just increase my DTU size and the kind of performance pick up I could expect?

[v-chuncz-msft · Accepted solution]

@ElliotP,

You may try File > Options and settings > Options > Diagnostics > Enable tracing in Power BI Desktop.