You could just out an SQL server somewhere and connect it as a datasource to Power BI. If you’d prefer a more standalone and SQL oriented Open Source solution, go ahead an checkout metabase as a BI platform.

However, I’m not aware of any BI platform providing APIs for data manipulation because displaying said data is usually the exclusive responsibility of a BI platform.