API Development from an Open-Source for Power BI Integration

I am interested in developing an API to retrieve data from an open-source housing index for my personal projects. My objective is to integrate this data with Power BI to create visuals and derive insights on a monthly basis, ensuring automatic refreshes when new data is published by the government each month.

Please ensure that the individual has familiarity with Power BI operations and API synchronization within it. I am eager to hear your proposal on this matter.

If you have the required skills and experience, please submit your proposal with relevant examples of previous API development projects.