cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChrisOnesBroken
Helper I
Helper I

On-premises data source: File type data source, intermittent network error - which log files?

We have a number of data sources on-premises added to the PowerBI service, these are File type data sources.  We have an On-premises data gateway cluster with two servers, both running the latest version of the OPDGW (3000.122.8).

 

Each morning, we have around 15 files which are on a scheduled refresh every couple of hours during the morning and early afternoon.  This last week we've been getting the data sources intermittently failing, with an error as follows;

 

An error occurred while processing the data in the dataset.

Refresh failed:

[#Data Source Name#] has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"<pi>The specified network name is no longer available.\r\n</pi>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"[#Local UNC Path to file used as data source#]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: [#Data Source Name#] Data Table.

Next refresh for [#Data Source Name#] is scheduled for May 6, 2022 12:30 UTC.

 

Not all data sources fail, its inconcistant which data sources fail.  Sometimes its 5 or 6 of them, sometimes its just one.  Each time its different data sources.  Every time it fails, I immediately confirm that the file path is in fact there, and is there from the servers that the on-premises data gateway servers are on.

 

I've been trawling through the On-Premises data gateways logs once i've exported them, but I can't seem to locate which log file an error like that should appear in.  Can anyone point me in the right direction?

1 REPLY 1
lbendlin
Super User
Super User

The only ones who can interpret these gateway logs are Microsoft and their system partners. Raise a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/ and let them figure it out.

 

Note:  Where possible you should use Folder or Sharepoint Folder data sources rather than File data sources.  That will drastically reduce the number of gateway connections that you need to maintain.

 

Note 2: You can (ab)use the try ... otherwise ...  Power Query concept to immediately attempt another connection. Also use Binary.Buffer and Function.InvokeAfter as needed.

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors