Forum Discussion
Web V2 connection problem
Hello,
I recreated my report from scratch and my problem solved itself, without any change in PowerQuery. Thanks for the help !
Hi Pronocalme , thank you for reaching out to the Microsoft Fabric Community Forum.
Sorry to know it isn’t working. Please consider below steps to ensure you are using a Web V2 connection.
- In Power BI Desktop -> Go to Transform Data -> New source -> web -> Choose Advanced.
- In the "Advanced" settings, ensure that you select "Web V2" as the connection type. If you do not see this option directly, it might be configured within the API key or authentication settings.
- Enter your API endpoint URL in the "URL parts" section.
- Select ‘Add header’ -> Select Authorization in Dropdown (type it in if it's not listed).
- Click "Done" to apply the query.
Power Query Web Connector - Microsoft Learn
https://learn.microsoft.com/en-us/powerquery-m/web-contents
If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.
2. In the "Advanced" settings, ensure that you select "Web V2" as the connection type. If you do not see this option directly, it might be configured within the API key or authentication settings.
News to me, and not supported by your screenshot. Are you using a prerelease version?
Hi lbendlin, Thanks for your reply. Apologies for not explaining it clearly.
As of October of 2021, Power BI Desktop uses Microsoft Edge WebView2, by default, for OAuth authentication for all connectors. so, i can't share a screenshot showing me selecting Web V2. But as i am not sure which version Pronocalme is using, i gave two ways to ensure Web V2 is used.
Please refer the below documentation:
https://learn.microsoft.com/en-us/power-query/oauth-edge-chromium
Thank you.