What we do is get the output from the API, save as csv files, then use those files in Power BI. It is taking a bit of time to load though. Can you recommend a better approach to link the API to Power BI?
@lisa.santamaria.RDP
Thanks for reaching out to us.
I don't know so much about Power BI but I found an article about Run Python scripts in Power BI Desktop on the Microsoft website. It demonstrates how to run Python scripts directly in Power BI Desktop and import the resulting datasets into a Power BI Desktop data model.
I hope that this information is of help.
