Data from public API

[Pan_Forex]

Hey guys, I'm trying to get data from public API using python script. Data is available without keys, logins, etc. I try to download all data for beforeId>90000. The code looks like this.

import requests



before_id = 90000
matches = []



while True:
url = f"https://api.settlers-united.com/matches?beforeId={before_id}"
response = requests.get(url)



 if response.status_code != 200:
print("error")
break



data = response.json()



if not data:

print("no more data")
break



matches += data
before_id = data[-1]['id']

     

print(f"saved amount: {len(matches)}")

In pycharm everything works and downloads data while powerbi after a few minutes does not download anything. I tried via "get data" -> "python script".