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

     

     

v-kelly-msft's avatar
v-kelly-msft
Community Support
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

Hi v-kelly-msft 

 

This has resolved the issue, this data source can now connect to the gateway successfully. Thanks very much for your help 🙂

 

Olivia