Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

On-Premise Data Gateway error for Web Data Source - underlying error: (404): File Not Found

I have a Power BI Desktop file published in the Power BI Service that uses 3 different data sources, however these all point to lists in the same SharePoint 2013 (on-premise) site. I have found that ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ,

     

    Try to add the following query into query editor:

     

     let 
Source = Web.Contents("http://<ServerName>.com/<SitePath>/<SiteName>",[RelativePath = "/_vti_bin/owssvr.dll?XMLDATA=1&List={<ListID>}&View={<ViewID>}&RowLimit=0&RootFolder=%2f<SitePath>%2f<SiteName>%2fLists%2f<ListName>Selection={<ItemID>}-{<ItemID>}EditWebPage=Formatting=NonePreFormattedTextToColumns=TrueConsecutiveDelimitersAsOne=TrueSingleBlockTextImport=FalseDisableDateRecognition=FalseDisableRedirections=FalseSharePointApplication=http://<ServerName>.com/<SitePath>/<SiteName>/_vti_binSharePointListView={<ViewID>}SharePointListName={<ListID>}RootFolder=/<SitePath>/<SiteName>/Lists/<ListName>&IncludeVersions=TRUE"])
in
Source

     

     

    if it's okay,then publish the .pbix file to service,and then configure the data source to see whether there's an error.

     


    Best Regards,
    Kelly

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have a Power BI Desktop file published in the Power BI Service that uses 3 different data sources, however these all point to lists in the same SharePoint 2013 (on-premise) site. I have found that by using different data connectors, I can achieve everything I need to for this report. Details of connectors used, are:

  1. SharePoint list (good for accessing basic list data): http://<servername>.com/<sitepath>/<sitename>
  2. OData feed (good for accessing and formatting list data such as "Person or Group" field values): http://<servername>.com/<sitepath>/<sitename>/_vti_bin/ListData.svc
  3. Web (to access all version history for all list items in one table): http://<ServerName>.com/<SitePath>/<SiteName>/_vti_bin/owssvr.dll?XMLDATA=1&List={<ListID>}&View={<ViewID>}&RowLimit=0&RootFolder=%2f<SitePath>%2f<SiteName>%2fLists%2f<ListName>Selection={<ItemID>}-{<ItemID>}EditWebPage=Formatting=NonePreFormattedTextToColumns=TrueConsecutiveDelimitersAsOne=TrueSingleBlockTextImport=FalseDisableDateRecognition=FalseDisableRedirections=FalseSharePointApplication=http://<ServerName>.com/<SitePath>/<SiteName>/_vti_binSharePointListView={<ViewID>}SharePointListName={<ListID>}RootFolder=/<SitePath>/<SiteName>/Lists/<ListName>&IncludeVersions=TRUE

I have successfully run this report on a scheduled refresh (twice daily) for the last 6 months via a personal data gateway. We are now setting up an on-premise data gateway and while I have managed to establish two of the three sources successfully (listed above 1 & 2), I am seeing a "File Not Found" error for the third (listed above 3). Here are the details of the error I am seeing:

 

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."

Activity ID:

<Activity ID>

Request ID:

<Request ID>

Cluster URI:

https://wabi-south-east-asia-redirect.analysis.windows.net/

Status code:

400

Error Code:

DMTS_PublishDatasourceToClusterErrorCode

Time:

Mon Jan 13 2020 11:19:35 GMT+1300 (New Zealand Daylight Time)

Service version:

13.0.11747.315

Client version:

1912.2.031

 

GGLAZAUEPBIVM02-Gateway:

Unable to connect to the data source undefined.

Underlying error code:

-2147467259

Underlying error message:

Web.Contents failed to get contents from 'http://<ServerName>.com/<SitePath>/<SiteName>/_vti_bin/owssvr.dll' (404): File Not Found

DM_ErrorDetailNameCode_UnderlyingHResult:

-2147467259

Microsoft.Data.Mashup.ValueError.DataSourceKind:

Web

Microsoft.Data.Mashup.ValueError.DataSourcePath:

http://<ServerName>.com/<SitePath>/<SiteName>/_vti_bin/owssvr.dll

Microsoft.Data.Mashup.ValueError.Reason:

DataSource.Error

Microsoft.Data.Mashup.ValueError.Url:

http://<ServerName>.com/<SitePath>/<SiteName>/_vti_bin/owssvr.dll

 

 

Is there any way we can get this data source successfully added to the new gateway? Many thanks in advance 🙂