Power BI premium regions

[Jos88]

Hi fellow PBI developers,

I was refreshing a large dataset (based on a big table) when I got this waiting type on the database ASYNC_NETWORK_IO which triggered me. This may indicate that the SQL engine is waiting for the client (Power BI) to process the data, before it continues to collect the next chunk of data (I think). This whole process took way too long before it timed out. So I started diggigin and I found out that the premium capacity is in a different region than the data (North vs West). To me this seems really inefficient and might be causing the trouble refreshing the data, since it has to travel between regions.

I'm not quite certain though, so I'm hoping someone could confirm on this or give me a bit more insight

[v-xiaotang · Accepted solution]

Hi @Jos88 

Thanks for reaching out to us.

>> I found out that the premium capacity is in a different region than the data (North vs West).

You can refer to the flow chart below, although it is the troubleshooting process of the report, but for refresh, they still have similarities

Troubleshoot report performance in Power BI - Power BI | Microsoft Docs

Additionally, you can use fiddler to track refresh activity, which steps up to each request and its duration.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.