URL : how to validate question when connecting

It is possible to pass a parameter to a URL using Power Query in order to get the information for a specific week. Here is an example of how you can achieve this:

1. Open Power Query Editor in Power BI Desktop or Excel.
2. In the "Home" tab, click on "From Web" in the "Get Data" section.
3. In the "From Web" dialog box, enter the URL "https://maree.info/7" and click "OK".
4. In the "Navigator" dialog box, click on "Edit" to open the Power Query Editor.
5. In the Power Query Editor, click on "Add Column" in the "Add Column" tab.
6. Select "Custom Column" and enter the following formula in the formula bar:

= Web.Contents("https://maree.info/7?d=20230206&accept=1")

Replace "20230206" with the date for the week you want to retrieve information for. The "&accept=1" parameter is added to indicate that the user has accepted the conditions. 7. Click "OK" to create the new column. This will send a request to the URL with the specified parameter and retrieve the information for the specified week.

Note: Depending on the website's terms of use, automated data scraping may not be allowed. Please ensure that you have permission to access and use the data from this website.