Forum Discussion

petrutjim's avatar
petrutjim
Frequent Visitor
4 years ago

Web Datasource - Working in Excel but not in Power BI

Hi,

 

We have an internal web datasource link like this: http://domain/webquery/Default.aspx 

 

When trying to connect within Excel, via VPN and WEB connector, it works fine and retrieves the data (a table) but when I do it in PowerBI (also with WEB Connector) I get this error: 

"The remote name could not be resolved: 'domain'"

 

Can you please advise on what to do?

Version of PBI is December 2021.

 

Thank you in advance!

Show and Tell

7 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    That is to be expected. The Power BI service has no idea how to reach your on-premise data source.  You need to setup a Power BI gateway.

  • petrutjim's avatar
    petrutjim
    Frequent Visitor
    4 years ago

    Hi. I don't understand how Excel can connect to that source, or how can we access the table via a web browser, but Power BI needs a gateway...?

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      4 years ago

      You need a gateway for any on-premise data source if you want to refresh from that data source in the service.

       

      Not relevant for Power BI Desktop.

      • petrutjim's avatar
        petrutjim
        Frequent Visitor
        4 years ago

        Yes, I forgot to mention in the initial post that this is happening in Power BI Desktop, not Service.

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, petrutjim 

    Please let me know if your issue has been resolved.
    If the issue persists, it is recommended to create a support ticket and let MS engineers look into the issue on your side.

    Best Regards,
    Community Support Team _ Eason