Forum Discussion
Need help with Web connector that using that requires building custom M Queries
Details - how we can transform our existing Webservice link (using Web connector) – this requires building a custom API within our M query to pass the header and body with the request to access the file and render the data. This process authenticates the link, allowing us to pull the data.
ANy sugeestion are highly appreciated !
2 Replies
- DallasBaba
Skilled Sharer
pandeyv2 To transform an existing Webservice link using the Web connector, you can build a custom API within your M query to pass the header and body with the request to access the file and render the data.
The Power Query Web connector is a powerful tool that allows you to connect to a URL and retrieve data from a web page. This connector can load data from a website with Power Query Desktop. To do so, select Get Data > Web in Power BI or From Web in the Data ribbon in Excel. Then, choose the Basic button and enter a URL address in the text box. A warning icon will appear next to the URL textbox if the URL address you enter is invalid.
You can read more on Microsoft Learn & Microsoft Learn
This YouTube video should be helpful for you.
Please click Accept as a solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was helpful in other ways, please consider giving it a Thumbs Up.Best Regards,Dallas. Thanks Dallas.
Can anyone in the community help me with building M query to access the endpoint data.
Any help will be highly appreciate.
Requirement - We just have authentication and two parametrs that we apss with request.Thanks !
