Forum Discussion

Ditto110's avatar
Ditto110
Advocate I
10 years ago

PBI Desktop Will Refresh - Scheduled is Intermittant

Hi everyone. Having an issue I can't crack!

 

I have several visuals in PBI Desktop. There are 3 data sources. Two of them are on premises SQL Server sources. The other is an Acces DB that I set up. I need this to match flight numbers together (ie 901 & 902 are both assigned 901/902 so that I can see the performance of an individual flight, or the entire flight). I have disabled data refresh of the Access DB - refreshing manually only if there is a new flight number in the system. 

 

When I schedule a refresh or manually try to refresh on the PBI website, it attempts for 20 minutes or so, then ends with this error:

 

Data source type: 
Processing error:The underlying connection was closed: An unexpected error occurred on a send. The underlying connection was closed: An unexpected error occurred on a send. Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. An existing connection was forcibly closed by the remote host
Cluster URI:WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID:714895e7-cb4f-444c-bbae-2bcbf411ec2c
Request ID:9321469e-82c6-e0c1-78db-4729ee4bdc29
Time:2016-03-28 20:16:51Z

 

 

I can refresh from PBI Desktop every time - and have no issue publishing to the web. I am on a work network, if that is relevant. There have been times when it has refreshed on schedule, but more often than not it fails. I do have a personal gateway installed, and is connected during refresh attempts.

 

This really has be stumped. The reports I have built are great when they refresh, but without successfully getting new data added they aren't of much use. Appreciate any help whatsoever anyone can offer!

 

Cheers

Need Help

2 Replies

  • Ditto110's avatar
    Ditto110
    Advocate I
    10 years ago

    Hi again. This morning I have tried uninstalling and reinstalling the personal gateway without success. I have read that my error relates to the filesize exceeding 250 MB, however my file is less than 1 MB. Appreciate any feedback!