Forum Discussion
Web V2 connection problem
- 1 year ago
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.
Thanks for your reply. Can you please tell me how to select "Web V2" as the connection type as you said there :
"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."