Import fails - read ECONNRESET

[kevhav]

Hi, I've been using the CLI successfully for months, to import a PBIX file to an Azure workspace collection.

Lately, my PBIX has been getting bigger, and sometimes the import has failed -- after waiting ~10 minutes, I get back 'read ECONNRESET'. Seems like a timeout. And today, I tried again, and I am consistently getting this failure. I've tried many times, at different hours—morning, noon and night—and it won't go through.

The PBIX is now a bit over 100 MB. I don't think that my Internet connection is the issue; I can upload a 100 MB file to another destination in ~1-2 minutes.

Any suggestions?

[ali-hamud]

Timeout could happen for large file due to redirecting the request between servers.
to solve that, you need to use the flag: PreferClientRouting.
https://msdn.microsoft.com/en-us/library/mt243840.aspx

by passing PreferClientRouting=true, Power BI will not route your request if needed, instead, you will get a response with the following details:
Response Code: 307 - HttpStatusCode.RedirectKeepVerb
Location Header: location header will have the URL you need to forward the request to.

CLI doesn't support this feature, so you need to use REST api call.