Power BI & Excel expert in REST APIs with Power BI, Excel

i need a Power BI & Excel expert in REST APIs with Power BI, Excel and Other Advanced Techniques, I need someone able to connect to https://developer.company-information.service.gov.uk/
https://find-and-update.company-information.service.gov.uk/

to create a Power BI & Excel files, that can be updated with multiple UK business records of UK companies. etc like CompanyName CompanyNumber RegAddress.CareOf RegAddress.POBox RegAddress.AddressLine1 RegAddress.AddressLine2 RegAddress.PostTown RegAddress.County RegAddress.Country RegAddress.PostCode CompanyCategory CompanyStatus CountryOfOrigin DissolutionDate IncorporationDate Accounts.AccountRefDay Accounts.AccountRefMonth Accounts.NextDueDate Accounts.LastMadeUpDate Accounts.AccountCategory Returns.NextDueDate Returns.LastMadeUpDate Mortgages.NumMortCharges Mortgages.NumMortOutstanding Mortgages.NumMortPartSatisfied Mortgages.NumMortSatisfied SICCode.SicText_1 SICCode.SicText_2 SICCode.SicText_3 SICCode.SicText_4 LimitedPartnerships.NumGenPartners LimitedPartnerships.NumLimPartners URI PreviousName_ etc, basically every single record, that can be downloaded, i want all columns

I want to be able generate, any number of business records , at the same time, not just singular records, grouped by company name

I need Power BI & Excel files that are optimized, so that they don't crash or are slow
I don't need any dashboards, only API connection, work must be done using Power BI, Excel , Power Query etc.

No Python or C development etc.