Hi,
Relatively new here so give me a chance!
I have a script in Python that takes a list of company numbers I am interested in and pulls back the required data for those companies. In this instance I am looking for directors. This script does what it is intended to do and i end up with a JSON file that i can upload into Power BI and use as required.
I’m attempting to now replicate that process but using Power BI as the list of companies is already in there.
Does anyone have any knowledge of how to do this? I can access the API via Power BI but have no idea how to link it to my list of company numbers and pull data for each.
Many thanks,