so I have the access to a company API, I have the skills to fetch the API and get the data using python, I just need to know how to create a pipeline to power bi or google data studio to create a dashboard/report that can be updated whenever new data gets added to the API

like do I use a SQL database or use another service?

the data will be transformed in the python script and then load it into the dashboard, again I have the necessary skills to create a dashboard and clean the data, I just need to know what approaches I can take to create an automated pipeline

i want to use google data studio more, but if you have any ideas in power bi then it's okay.