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

Hi v-kelly-msft 

 

Thanks for your reply, we have the latest version of the software and have completed the checks you suggested:

  1. Port 80 is being used.
  2. On this version of SharePoint, we don't use https. Is that an issue? Like I said I have successfully configured the other data sources which query this same site. 
  3. My colleague restarted the gateway and I am still seeing this error.
  4. We have exported the data gateway log, should I send this to you directly to help further? 

 

Many thanks,

Olivia

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi Anonymous ，

 

If so ,pls try to shift to  HTTPS instead of direct TCP,then restart the gateway  and see if the error still occurs.

 

Best Regards,

Kelly

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-kelly-msft 

     

    I have checked and HTTPS was already enabled. Is there anything else we can do?

     

    Thanks

    Olivia

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      6 years ago

      Hi Anonymous ，

       

      Try to use an empty .pbix file to connect with the following URL using a web connector(shown as below):

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

      Don't write any parameters inside,then publish to service to check whether it can configure the  datasource from sharepoint.

      Sometimes it may happen when the gateway machine cant visit the datasource, using the above steps to rule out the factor.

       

      Best Regards,

      Kelly

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi v-kelly-msft 

         

        I tried this and I get file not found errors in both Power BI Desktop and in a browser. When I enter the full URL I see the data in both places. I think this is due to the conversion of the data to XML? That's what the rest of the URL defines. 

        My colleague configuring the gateway has also confirmed that when he puts the full URL into the browser on the server the gateway is configured on, he sees the XML data as well.

         

        Thanks

        Olivia