Forum Discussion
What code development is required to connect to the Rest API using the Web Data Connector (Get Data>
- 2 years ago
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:
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.
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.
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.
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.
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 !!
Hi Tangelo-tech
If possible, move the data to a cloud-based storage service like Azure Blob Storage or Azure SQL Database. Once the data is in the cloud, Power BI can access it directly without the need for a gateway.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous How to move the data to a cloud-based storage service like Azure Blob Storage or Azure SQL Database?Do I need to buy an Azure server first?