Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Jos88
Regular Visitor

Power BI premium regions

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

1 ACCEPTED SOLUTION
v-xiaotang
Community Support
Community Support

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

vxiaotang_0-1659924968483.png

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.

View solution in original post

1 REPLY 1
v-xiaotang
Community Support
Community Support

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

vxiaotang_0-1659924968483.png

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors