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 ，

 

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

      • 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