Euromillions import game and financial data

Valentin

New member
Joined
Oct 22, 2018
Messages
3
Reaction score
0
Points
0
Excel Version(s)
365
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
euromillions.png


But I want to import the data directly from the server. is this possible with Power Query?
 
In power query, have you tried

Get and Transform-->New Query-->From Other Sources-->From Web
 
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.
 
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]
 
Back
Top