Forum Discussion

Tangelo-tech's avatar
Tangelo-tech
Helper I
2 years ago
Solved

What code development is required to connect to the Rest API using the Web Data Connector (Get Data>

Hi, I want to create a template app to put in the power bi marketplace which contains data from my web.When I connect to a data source in Power BI Desktop, I choose to retrieve data from the web. I ...
  • johnbasha33's avatar
    2 years ago

    Tangelo-tech 

    It seems like you're trying to create a Power BI template app that connects to a web data source using parameters, but you're encountering an error message stating that connecting to data sources requiring a local gateway is not supported.

    Here's what you can do to address this issue:

    1. Data Source Connectivity: The error message indicates that connecting to data sources requiring a local gateway is not currently supported. This means that the web data source you're trying to connect to may require a local gateway for connectivity, and template apps do not support this type of connection.

    2. Alternative Data Source: Consider using a different data source that does not require a local gateway for connectivity. Power BI supports a wide range of data sources including databases, cloud services, APIs, and more. You may be able to find an alternative data source that meets your requirements and does not require a local gateway.

    3. Parameterized URLs: If you're unable to use a different data source, you may need to modify your approach to use parameterized URLs within Power BI. This involves creating a parameterized query in Power BI Desktop and passing parameters to the URL dynamically. However, this approach may not be feasible if the web data source specifically requires a local gateway for connectivity.

    4. Contact Support: If you believe that the error message is incorrect or if you require further assistance, you can contact Microsoft Power BI support for help. Provide the details mentioned in the error message, such as the activity ID and request ID, to help them investigate the issue further.

    5. Consider Workarounds: Depending on your specific requirements, you may need to explore alternative solutions or workarounds to achieve your goals. This could involve using custom connectors, data preprocessing, or other techniques to connect to and retrieve data from your web data source.

      Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!