ty, not reinventing is the purpose of my post :) I've explored using PowerBI a bit, it doesn't seem to be geared towards extracting the data once it's in PowerBI. I'd want to be able to query the data from other services, for example grafana so that we could set up alerting. There doesn't seem to be a clean way to do this, all I could find was https://learn.microsoft.com/en-us/rest/api/power-bi/datasets...
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.
No need to re-invent the wheel with your own DB.
https://www.reddit.com/r/PowerBI/comments/s3o6hi/the_most_in...