Euromillions import game and financial data

[Valentin]

I want to import the data of "EuroMillionsGameData.csv" and "EuroMillionsFinancialData.csv" in Power Query, from the website "https://www.nationale-loterij.be/nl/onze-spelen/euromillions/resultaten" there is only a download link

Trekkingresultaten =

EuroMillionsGameData.csv
Financiele resultaten =

EuroMillionsFinancialData.csv​

​

But I want to import the data directly from the server. is this possible with Power Query?

 

[alansidman]

In power query, have you tried

Get and Transform-->New Query-->From Other Sources-->From Web

 

[Valentin]

Yes I have tried the method “Get and Transform-->New Query-->From Other Sources-->From Web”, but I cannot find the two url’s that refer to the two files.
In the past this was the case, but the website has been renewed in the meantime.
I suppose the data can be obtained with the methode "Get" or "Post", but my knowledge does not go far enough to get this done.
Someone an idea if this is possible and possibly a solution.

 

[Valentin]

Solved i think

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://www.nationale-loterij.be/drawresults/downloadcsv/onze-spelen/euromillions/uitslagen-trekking/23-10-2018?startDate=02%2F01%2F2004%2000%3A00%3A00&endDate=12%2F31%2F2030%2023%3A59%3A59&gameId=Elot&resultsType=0

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://www.nationale-loterij.be/drawresults/downloadcsv/onze-spelen/euromillions/uitslagen-trekking/23-10-2018?startDate=02%2F01%2F2004%2000%3A00%3A00&endDate=12%2F31%2F2030%2023%3A59%3A59&gameId=Elot&resultsType=1[/FONT][SUB][SUP]
[/SUP][/SUB][/FONT]