Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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.
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
54 | |
41 | |
31 | |
29 | |
22 |